Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |