divide a string words separated by (number)
On Thu, 3 Jun 2010 14:46:26 -0700, ferde
wrote:
I would like to have the data that is in one cell parsed into two cells like
in the example below. The data is always separated by a consecutive whole
number in parenthesis . Thank you
A
(1.) White Dog (2.) Black Cat
A B
White Dog Black Cat
B1:
=TRIM(MID(A1,FIND(")",A1)+1,FIND("(",A1,FIND("(",A 1)+1)-FIND(")",A1)-1))
C1:
=TRIM(MID(A1,FIND(")",A1,FIND(")",A1)+1)+1,255))
|