how to parse or split data (with brackets) into 2 cells

[Stuart Gladwell]

I have a cell with

(08)237

in it and need to create a cell with the integers contained between
the brackets ie 08 in the first cell and following integers after
the closing bracket contained in the second cell ie 237

(I imagine the cell contents will have to be allocated as a text?)
I will be exporting from this worksheet in a csv format. Using EXCEL
97 on win NT.

Any ideas gratefully received!

STuart

[Harald Staff]

Hi Stuart

I have to guess a little, my excel is translated, so the function names
may not be accurate:
Number in A1, To extract the 08 in B1:
=MID(B1;2;FIND(")";B1)-2)
To extract the 237 in C1:
=RIGHT(F1;LEN(A1)-LEN(B1)-2)
...Will be text, yes. To restore the values in neighbor cells:
=B1*1 and =C1*1
Hope this works. Best wishes Harald

[Buster]

Go to the Data option on the menu and select text to column under the
choices presented choose delimited text and use ) as yhe delimeter this will
extract the information into two columns one with (# and the other with the
3 digit number simply highlight the column with the (# and go to rplace
under the edit menu and put ( in the find field and leave the replace field
blank to remove all of the forward brackets and whoala two columns with the
information broken out.
Stuart Gladwell wrote in message <353b73d4...@news.tig.com.au>...

[Ogilvy, Thomas W., Mr., ODCSLOG]

Stuart,
If the parentheses will always start in the first postion of the string
then these two functions will get the job done. Put the first one in
the column where you want the numbers inside the parentheses and the
second in the column where you want the number to the right of the
parentheses.
The formulas were written with the source number in cell "B9"

=MID(LEFT(B9,SEARCH(")",B9,1)-1),2,LEN(LEFT(B9,SEARCH(")",B9,1)-1))-1)
=RIGHT(B9,LEN(B9)-SEARCH(")",B9,1))

B C D
<<...>>

There are other formula combinations which can get the job done - maybe
some simpler than these.
HTH,
Tom Ogilvy

> ----------
> From: stu...@tig.com.au (Stuart
> Gladwell)[SMTP:stu...@tig.com.au]
> Posted At: Monday, April 20, 1998 12:17 PM
> Posted To: worksheetfunctions
> Conversation: how to parse or split data (with brackets) into
> 2 cells
> Subject: how to parse or split data (with brackets) into 2 cells