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