Hi:
I have a excel file with columns values Shaded/Active I need to get sub string before / Any idea?
Thank you in advance
Hi:
I have a excel file with columns values Shaded/Active I need to get sub string before / Any idea?
Thank you in advance
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.
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 :)
=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