I have a webpage that lists business names, address, phone number, etc.
There is no definite pattern to how they entered the text. What I'd
like to do is something like....

-Search cell A1 for "-", return the 3 characters to the left of the
"-".-

In the next column do...

-Search cell A1 for "-", return the 4 characters to the right of the
"-".-

Then I can concatenate the two and add in the area code.

TIA guys/gals.


PS. I tried searching but didn't know exactly what to search for and
didn't get very far.


--
Tech
------------------------------------------------------------------------
Tech's Profile: http://www.excelforum.com/member.php...o&userid=15107
View this thread: http://www.excelforum.com/showthread...hreadid=392890