Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-10-2017, 06:12 AM
shield5 shield5 is offline Separating text in one Column into two Columns Windows 7 64bit Separating text in one Column into two Columns Office 2007
Novice
Separating text in one Column into two Columns
 
Join Date: Oct 2013
Posts: 5
shield5 is on a distinguished road
Default Separating text in one Column into two Columns

Hi

Attached an Excel sheet that contains text in Column A, What I would like to do is separate the text in the table of contents, under the Description heading text goes in column B, While the text under Values heading to goes in Column C.



Thanks
Attached Files
File Type: xlsx Excel Question.xlsx (9.3 KB, 10 views)
Reply With Quote
  #2  
Old 01-10-2017, 07:25 AM
xor xor is offline Separating text in one Column into two Columns Windows 10 Separating text in one Column into two Columns Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
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

Should A3 and A4 (and similarly A5 and A6) be regarded as one description?
If yes then I have no ideas.
Reply With Quote
  #3  
Old 01-10-2017, 08:35 AM
shield5 shield5 is offline Separating text in one Column into two Columns Windows 7 64bit Separating text in one Column into two Columns Office 2007
Novice
Separating text in one Column into two Columns
 
Join Date: Oct 2013
Posts: 5
shield5 is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
Should A3 and A4 (and similarly A5 and A6) be regarded as one description?
If yes then I have no ideas.
Yes it is one description.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Separating text in one Column into two Columns Word 2013: Separating text in a caption al.25 Word 3 04-01-2014 03:04 PM
Separating text in one Column into two Columns Column text flow with table across the columns ravenns Word 3 07-11-2013 11:29 PM
Columns. How to move the left column so it's to the right of the 'right' column ? Vit Word 9 11-21-2012 12:57 PM
Separating text in one Column into two Columns Separating endnotes from text kenglade Word 22 09-14-2012 04:10 PM
Separating text in one Column into two Columns How to expand one column into two columns? Jamal NUMAN Excel 1 01-12-2011 07:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:49 AM.


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