PC Review

New Member
Join Date: Jul 2012
Posts: 1
      22nd Jul 2012
How to undo a CONCATENATED file created by CONCATENATING two columns?

Reply With Quote
Excel Formulator
alow's Avatar
Join Date: Mar 2012
Location: US
Posts: 758
      23rd Jul 2012
What does the data look like now? It depends on if the stuff you want to separate out is all the same length, or if there is a variable to it. If you wanted to take the first 5 characters in one column and the last 7 characters in another, you would use =RIGHT(a1,5) in one column, and =LEFT(a1,7) in another to pull it apart.
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Import Excel 2010 table into Access 2010 - not listed as range rob11marmion@gmail.com Microsoft Access External Data 1 17th Feb 2013 11:04 PM
Excel 2010 Table not showing in Access 2010 Import List rob11marmion@gmail.com Microsoft Excel Discussion 0 21st Dec 2012 06:22 AM
Form 4 Range of time from 1/20/2010 4:00 AM To 1/21/2010 10:00 AM Peter Gonzalez Microsoft Excel Worksheet Functions 2 26th Jan 2010 07:58 PM
Can't open workbook in excel 64 bit 2010 - but can in excel 2010 3 Darrell Microsoft Excel Programming 5 12th Jan 2010 10:03 PM
Office 2010 & Outlook 2010 and Business Contact Manager AvrahamC Microsoft Outlook BCM 0 4th Jan 2010 02:56 PM




All times are GMT +1. The time now is 11:15 AM.