Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) |