Need help extarcting String in Excel (SHADED/ACTIVE) Need column showing only SHADED

Question

Hi:

I have a excel file with columns values Shaded/Active I need to get sub string before / Any idea?

Thank you in advance

Answer 1

I think it would be better to add another column which serves as a flag to know if its shaded/active. I'm not sure if there;s way to know if a cell is shaded.

Answer 2

Copy the column to text file (Notepad)

Paste list to excel and use text import wizard. Select option Delimited and select / This will give you 2 columns :)

Answer 3

=LEFT(A1, SEARCH("/", A1) - 1)

That's assuming that your cells actually contain the text: Shaded/Active and you want to extract the part before the /

You might need to clarify the question a bit if that isn't what you are looking for