Separating Text

[franklin85 via OfficeKB.com]

Hi All,

I have a string of text in a Cell, and I wish to split it up so that I can
group together by the relevant bits.

For exampe - 1000/2000/3000/ABC.

I need to split up each of the numbers into their own cells. I can do the
first and last bits by using the =Left and = Right formula, but I am
struggling to remember how to do the bits in the middle.

Hope somebody can help!

Many thanks
Franklin

 

[Gary''s Student]

With data in A1:

=LEFT(A1,4)
=MID(A1,6,4)
=MID(A1,11,4)

 

[David Biddulph]

Data/ Text to columns/ Delimited
Use the slash symbol as the delimiter.