| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting my cell
hey all
i have a cell like the following: 1|2 can someone please show me how to put the 1 and the 2 in 2 separate columns? thanks, rodchar |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
splitting my cell
Try Data Text to Columns Delimited (type the separator*: |)
*Press Shift + Backslash key -- Max Singapore http://savefile.com/projects/236895 Downloads:16,200 Files:354 Subscribers:53 xdemechanik --- "rodchar" wrote: hey all i have a cell like the following: 1|2 can someone please show me how to put the 1 and the 2 in 2 separate columns? thanks, rodchar |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
splitting my cell
that worked great thanks, by the way, is there a formula that can do the same
thing? "Max" wrote: Try Data Text to Columns Delimited (type the separator*: |) *Press Shift + Backslash key -- Max Singapore http://savefile.com/projects/236895 Downloads:16,200 Files:354 Subscribers:53 xdemechanik --- "rodchar" wrote: hey all i have a cell like the following: 1|2 can someone please show me how to put the 1 and the 2 in 2 separate columns? thanks, rodchar |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
splitting my cell
Data/ Text to columns/ delimited, and specify your | character as the
delimiter. -- David Biddulph "rodchar" wrote in message ... hey all i have a cell like the following: 1|2 can someone please show me how to put the 1 and the 2 in 2 separate columns? thanks, rodchar |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
splitting my cell
=LEFT(A1,FIND("|",A1)-1)
=RIGHT(A1,LEN(A1)-FIND("|",A1)) You can simplify the formulae if you know the number of characters either side of the | character. -- David Biddulph "rodchar" wrote in message ... that worked great thanks, by the way, is there a formula that can do the same thing? "Max" wrote: Try Data Text to Columns Delimited (type the separator*: |) *Press Shift + Backslash key -- Max Singapore http://savefile.com/projects/236895 Downloads:16,200 Files:354 Subscribers:53 xdemechanik --- "rodchar" wrote: hey all i have a cell like the following: 1|2 can someone please show me how to put the 1 and the 2 in 2 separate columns? thanks, rodchar |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
splitting my cell
With 1|2 in A1
B1 =Left(A1) C1 =Right(A1) Gord Dibben MS Excel MVP On Tue, 22 Jul 2008 06:11:00 -0700, rodchar wrote: that worked great thanks, by the way, is there a formula that can do the same thing? "Max" wrote: Try Data Text to Columns Delimited (type the separator*: |) *Press Shift + Backslash key -- Max Singapore http://savefile.com/projects/236895 Downloads:16,200 Files:354 Subscribers:53 xdemechanik --- "rodchar" wrote: hey all i have a cell like the following: 1|2 can someone please show me how to put the 1 and the 2 in 2 separate columns? thanks, rodchar |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting a Cell | Excel Worksheet Functions | |||
| splitting a cell | Excel Discussion (Misc queries) | |||
| Splitting a cell into two... | Excel Discussion (Misc queries) | |||
| Splitting a cell | Excel Worksheet Functions | |||
| Splitting a Cell | Excel Worksheet Functions | |||
Linear Mode
