Solved

splitting up a field into two columns

Posted on 2013-05-26
1
299 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 earned 500 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

896 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now