Copy and Paste Help
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. |
Copy and Paste Help
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 "dwake" wrote: 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. |
Copy and Paste Help
Select the column & then go to Data | Text to columns | check fixed
width | next | create break line between the text & number | next | finish On Sep 19, 3:13*am, dwake wrote: 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. |
All times are GMT +1. The time now is 09:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com