Separating Text
 

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200811/1

Separating Text
 

With data in A1:

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

--
Gary''s Student - gsnu200812


"franklin85 via OfficeKB.com" wrote:

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200811/1

Separating Text
 

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

"franklin85 via OfficeKB.com" <u47278@uwe wrote in message
news:8d07f6ea94225@uwe...
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200811/1