Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page convert list in one cell into multiple cells convert list in one cell into multiple cells
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 02-09-2016, 03:56 AM
RayK RayK is offline convert list in one cell into multiple cells Mac OS X convert list in one cell into multiple cells Office for Mac 2011
Novice
convert list in one cell into multiple cells 		 
Join Date: Feb 2016
Posts: 5
RayK is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 02-09-2016, 04:40 AM
xor xor is offline convert list in one cell into multiple cells Windows 10 convert list in one cell into multiple cells Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,103
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Select the cell with reg numbers.
Click Data, Text to Columns, choose Delimited, Next, tick Comma and press Finish.
Reply With Quote
  #3  
Old 02-09-2016, 04:53 AM
RayK RayK is offline convert list in one cell into multiple cells Mac OS X convert list in one cell into multiple cells Office for Mac 2011
Novice
convert list in one cell into multiple cells 		 
Join Date: Feb 2016
Posts: 5
RayK is on a distinguished road
Default Thanks
That worked thank you.
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert list in one cell into multiple cells Linking cells: can sub-cells move with their master-cell when sorting? kw01 Excel 1 06-30-2015 05:02 PM
convert list in one cell into multiple cells Convert non-cell input to cell values TBD Excel 3 06-09-2014 06:14 AM
convert list in one cell into multiple cells How to modify the figures and cell format in multiple cells at once? officeboy09 Excel 5 01-16-2014 07:41 PM
convert list in one cell into multiple cells Copy table cell formatting across multiple cells / tables pakistanray Word Tables 2 10-31-2011 08:07 AM
convert list in one cell into multiple cells Moving formula range multiple cells when moving sum over one cell FraserKitchell Excel 4 02-26-2010 10:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:22 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft