Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Text to columns
I have columns of cells that have information I need to separate into
separate cells Information in each cell will vary but they have one thing in common. The information is either a word with a number or just a number Example LASERJET 2000D LASERJET 2100 LASERJET 1100 1100A 1100AXI 1100SE 1100XI 3200 LASERJET 1010 LASERJET 1012 LASERJET 1015 LASERJET 3015 LASERJET MFC 8300 8500 8600 8700 9600 9700 9750 9800 Each line above is a cell. I am trying to separate these items such that each resulting cell has a word and a number or just a number the second line (cell) would look like Laserjet 1100 1100A 1100AXI 1100SE 1100XI 3200 Any ideas? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set text to fit columns? | Excel Discussion (Misc queries) | |||
text to columns: is there a formula? | Excel Worksheet Functions | |||
merging text columns | Excel Discussion (Misc queries) | |||
Text Columns Negative Numbers Upgrade Excel? | Excel Discussion (Misc queries) | |||
Text to columns | Excel Discussion (Misc queries) |