Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separating Text | Excel Worksheet Functions | |||
Separating text | Excel Discussion (Misc queries) | |||
separating text | Excel Worksheet Functions | |||
Separating text | Excel Worksheet Functions | |||
Separating text | Excel Worksheet Functions |