Frank Kobel

[Guest]

Hi Frank,

Not sure if you remembered this post but I'm having difficulty with the
formula you've provided; please see below previous post.

--------------------------------------------------------

Hi Frank,

This formula doesnt seem to be working for me.

I'm just copying and pasting the formula you've specified and pressing ctrl,
shift and enter.
Am I doing something wrong?

Not sure what the "--" signs are in the formula, is that correct?

 

[JulieD]

Hi Adam

the formula works fine for me using the following test data:
A1 - 123 cat
A2 - cat 123
A3 - the 123 cat
A4 - cat123

i copied frank's formula into E1:E4 and used ctrl & shift & enter to enter
it

the only thing i can think of is that your data is not in cell A1 ... or it
does not go down the column but across a row.

if you still can't get it to work, could you type out three or four examples
of your data.

Cheers
JulieD

 

[Don Guillett]

try using F2 to edit the formula and THEN do the CSE

 

[Dave Peterson]

And you have another reply at the original thread.