Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to split cells?
Can anyone help me? -- wsijbesma ------------------------------------------------------------------------ wsijbesma's Profile: http://www.excelforum.com/member.php...o&userid=35063 View this thread: http://www.excelforum.com/showthread...hreadid=548078 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to split cells?
hi
on the tool bar... datatext to columns. follow the wizard. caution.... this deletes data to the right when the cell is split you can also use formulas. cell A1 has the word "text in it. in cell B1... =right(a1,2) will return "xt" in cell C1... =left(a1,2) will return "te" in cell D1... =mid(A1.2,2) will return "ex" regards FSt1 "wsijbesma" wrote: Can anyone help me? -- wsijbesma ------------------------------------------------------------------------ wsijbesma's Profile: http://www.excelforum.com/member.php...o&userid=35063 View this thread: http://www.excelforum.com/showthread...hreadid=548078 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Split Cells using a Function | Excel Worksheet Functions | |||
can i somehow put two cells into one column or split a column | Excel Discussion (Misc queries) | |||
text cells end page how split to next. Text lost! | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |