String manipulation xxx/xxxx/xxxx//

**mikedu** · 04-13-2011, 03:50 PM

I have a char string 18978/309/106// that I want to extract each set of numbers. They differ in length. To get the first one was easy (formula =LEFT(A1, FIND("/",A1)-1)

I am having trouble getting the 2nd and third if anyone can help that would be great, thanks

**zbor** · 04-13-2011, 03:56 PM

Select column then Text to data -> Delimited and use / as delimiter

**jwright650** · 04-13-2011, 04:12 PM

zbor has it right......it will default to "," so uncheck that and check "other" then type a "/" in the box beside "other", that should give you nothing but numbers in seperate columns.

**TMS** · 04-13-2011, 04:33 PM

If you still want formulae:

=MID(A2,FIND("/",A2)+1,FIND("/",A2,FIND("/",A2)+1)-FIND("/",A2)-1)

=MID(A2,FIND("/",A2,1+FIND("/",A2))+1,FIND("/",A2,1+FIND("/",A2,1+FIND("/",A2)+1))-FIND("/",A2,1+FIND("/",A2))-1)

Regards