Currently Being ModeratedOct 23, 2012 9:44 PM (in response to KGE33)
Currently Being ModeratedOct 24, 2012 9:39 AM (in response to Barry)
Well, thank you so much for helping but for some reason when I put that exact string in, in a column to the right of my existing column, and pressing "option, return" after the first " - it still does not work. Gives me that red triangle that says the formula won't work?? I made sure to have an option return already in the column to the left.
Currently Being ModeratedOct 24, 2012 9:40 AM (in response to KGE33)
However, please don't spend much time on this either....I think I am having to go through this database in such detail already that it is easy to simply cut and paste into the second column!! Thanks again.
Currently Being ModeratedOct 25, 2012 12:22 AM (in response to KGE33)
The red triangle is an error flag, and comes with an error message describing (sometimes somewhat cryptically) the error that is being flagged. Knowing the error message might make it easier to explain why the formula is not working, and to offer a correction to the formula.
As written, the formula will work only if your block of text is in column A and the formula is in column B.