Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 10-08-2014, 04:20 AM
thetraininglady thetraininglady is offline how to split merged data into vertical saperate cells Windows 7 64bit how to split merged data into vertical saperate cells Office 2010 32bit
Competent Performer
 
Join Date: Sep 2014
Location: Sydney, Australia
Posts: 214
thetraininglady is on a distinguished road
Default

I'm assuming that the numbers have been entered into the one cell with a space separating each number. If yes this will take two separate steps to fix it.

1) Select the cell which contains the values and go to the Data tab on the Ribbon. Select Text to Columns. Choose the file type as DELIMITED and click Next. From the list of delimiters, tick the box for Space and click Next. Click Finish. The numbers should now be separated into their own cells across a row.

2) Now highlight all the cells which contain all the values and select Ctrl + C to perform a copy. Place your cursor into an empty cell and right mouse click the empty cell and choose Paste Special. From the options choose the Transpose option. The values should now be in their own cells vertically down the column.

Please let me know if you get stuck.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Accidentally merged cells? Fraser Excel 2 02-16-2014 10:15 PM
Excel Multiple Rows Merged into Word (Vertical Format) ats1025 Mail Merge 3 11-19-2013 02:21 PM
how to split merged data into vertical saperate cells Differences in borders at page break in merged cells Sudlav Word Tables 2 05-23-2013 11:50 PM
borders disappear from merged cells when pasting from excel joba Word 0 09-10-2012 11:35 AM
how to split merged data into vertical saperate cells Set range for merged Word table cells? tinfanide Word VBA 1 02-06-2012 05:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:28 PM.


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