Excel 2k7-

[tutuster]

Okay tipsters, I need you on this one.

My case is that in the cell A1 is a TEXT entry
"CompanyName Inc. (City)"
without "" of course

Now I need to get the city information to another column, and I need help to figure out the most efficient formula to do this. The city is ALWAYS in the end of the text in the cell, and always within brackets, as in the example.

Maybe it's the monday effect but I'm banging my head to the wall on this one..

Grateful for all tips!

 

[tutuster]

okay now it's for sure, it's the monday effect!

Sorry for the ultra descriptive header! Could some of the mods fine tune the title?

 

[SkipVought]

hi,

The simplest way is Data > Text to columns... DELIMITED using (

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[tutuster]

This is solved, I thought of that too but it would've ment i hand to copy the column and i did not want to do that.

I solved this the engineer's way, and sliced the wanted result to number of smaller formulas, and finally combined them. This seemed to be quite useful method in the end.

 

[xwb]

You can do it in 3 columns: just hide columns b and c.

b1 =search("(",A1)
c1 =search(")",A1)
d1 =mid(A1,B1+1,C1-B1-1)