Fastest way i can think of would be to do a control H and swap ( and ) for a
symbol not in use like *, then You can use a Data-Text to columns, choose
delimited, and put a check in space and special character with * in the box.
better to me especially if you have many columns making helper cells a
problem.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"hshayh0rn" wrote:

I have a cell that contains data that needs to be broken up among a few
different cells. The source cell contains data like:

COMPANYADDRESS2 VARCHAR2(35)

I need to put 35 in one cell and then VARCHAR in another. So I need a
worksheet function that finds the number between ( and ) and then I need
another function that figures out the characters between ( and the first
space to the left of the V in varchar2. Varchar2 is just an example of what
the data could be. Other examples could be number, date, etc...