Copy and Paste Help

D

dwake

I have a colum of serial no's and I want to segregate the prefix from the
last five digits. Each serial no. contains a three digit prefix followed by
a five number sequence, these numbers are not sequential in my spread sheet.

e.q.
A B C
1 ABC12345 ABC 12345
2 ABD12356
3 ABR12312

Is there anything I can do to automatically fill in the B and C columns
without having to invidually pull out. Is there a way to tell excell to look
at column A, input the first three digits into column B and the last five
digits into column C? Any help would be appreciated.
 
R

rajesh

Hi

Try this one:
In B1 & C1 use the below functions and drag it to end of the data
=LEFT(A1,3)
=RIGHT(A1,5)

Regards
rajesh
 
M

muddan madhu

Select the column & then go to Data | Text to columns | check fixed
width | next | create break line between the text & number | next |
finish
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top