View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
laandmc laandmc is offline
external usenet poster
 
Posts: 23
Default delimit using a formula

I am wanting to delimit a cell with both text and numbers in to separate out
the numbers which have common characters that delimit them from the rest of
the text.

I can do this using text to columns but I want to know whether I can do this
by using a formula instead.##e.g.

A
1 text (2/3) more text
2 text (3/4) more text

I want to get the results:

A B
1 2 3
2 3 4

using the first delimiter "(", then "/" then ")"

is there a way to write this in a formula to split up the numbers from the
text?

Cheers