Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

splitting up a field into two columns

Posted on 2013-05-26
1
Medium Priority
?
318 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

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

885 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