#1
|
|||
|
|||
convert list in one cell into multiple cells
I have copied a list of car reg numbers into one cell separated by a comma.
How do I convert this into a column with one reg in one cell only? |
#2
|
|||
|
|||
Select the cell with reg numbers.
Click Data, Text to Columns, choose Delimited, Next, tick Comma and press Finish. |
#3
|
|||
|
|||
Thanks
That worked thank you.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking cells: can sub-cells move with their master-cell when sorting? | kw01 | Excel | 1 | 06-30-2015 05:02 PM |
Convert non-cell input to cell values | TBD | Excel | 3 | 06-09-2014 06:14 AM |
How to modify the figures and cell format in multiple cells at once? | officeboy09 | Excel | 5 | 01-16-2014 07:41 PM |
Copy table cell formatting across multiple cells / tables | pakistanray | Word Tables | 2 | 10-31-2011 08:07 AM |
Moving formula range multiple cells when moving sum over one cell | FraserKitchell | Excel | 4 | 02-26-2010 10:38 AM |