UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> taking 1 column and making it 3 columns. (long # is in the 1st    
 
   
ipisors
post Jul 20 2007, 12:49 PM
Post #1

UtterAccess Certified!
Posts: 7,208
From: Arizona, United States
I have a column, each row is a 17 digit #. , i.e.: #################

What I want is to separate that neatly and precisely into 3 columns, as follows:

### ### ####### ####

Other than saving as text, then importing the text file back again at which time i could move those handy column markers in the import wizard, is there a simple way to do this, preserving all values of cells just inserting column lines at the right points?
Go to the top of the page
 
+
KingMartin
post Jul 20 2007, 12:56 PM
Post #2

Retired Moderator
Posts: 10,959
From: Prague,CZ / Kiev,UA
You want to parse the string into separate cells? 6,7,4 characters?

ColumnB
=LEFT(A1,7)
ColumnC
=MID(A1,8,6)
ColumnD
=RIGHT(A1,4)

copy, paste over as values. delete the original.

Martin
Go to the top of the page
 
+
norie
post Jul 20 2007, 01:07 PM
Post #3

UtterAccess VIP
Posts: 4,308
What about Data>Text to columns... with the fixed width option?
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 10:13 PM