?
Solved

splitting up a field into two columns

Posted on 2013-05-26
1
Medium Priority
?
327 Views
Last Modified: 2013-05-26
I have this column that needs to be split into two columns

GA01000142
VA06000035
VA06000261
VA06000265

Column 1
GA0

Column 2
1000142

The column consitential has a two letter prefix with a 0, how can you do it.
0
Comment
Question by:Amanda Walshaw
1 Comment
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 39198435
Hello,

select the cells, click Data > Text to columns > Fixed width > next click in the data table and drag the separator line where you need it. Then click "Finish".

screenshotdata
Or, you can use formulas to extract the first three characters

=left(A1,3)

and the last seven characters

=RIGHT(A1,7)

cheers, teylyn
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
In this post, we will learn to set up the Group Naming policy and will see how it is going to impact the Display Name and the Email addresses of the Group.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question