| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split 10 alphanumerics into 3 cells
What is the formula to split 10 alphanumerics into 3 cells?
I have A2 = 1067035C03 I need B2 = 1067, C2 = 035, D2 = C03 Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Split 10 alphanumerics into 3 cells
Vic
Data - Text to Columns - Fixed width and set the breaks OK Mike "Vic" wrote: What is the formula to split 10 alphanumerics into 3 cells? I have A2 = 1067035C03 I need B2 = 1067, C2 = 035, D2 = C03 Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Split 10 alphanumerics into 3 cells
Vic,
Just noticed you'll lose the leading zero in C2 so custom format that cell as 000 to get it back "Mike H" wrote: Vic Data - Text to Columns - Fixed width and set the breaks OK Mike "Vic" wrote: What is the formula to split 10 alphanumerics into 3 cells? I have A2 = 1067035C03 I need B2 = 1067, C2 = 035, D2 = C03 Thank you. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Split 10 alphanumerics into 3 cells
Try this...
Use this formula in B2 =TRIM(LEFT(A1,4)) Use this formula in C2 =TRIM(MID(A1,5,3)) Use this formula in D2 =RIGHT(A1,3) If this post helps, Click Yes! -------------------- (Ms-Exl-Learner) -------------------- "Vic" wrote: What is the formula to split 10 alphanumerics into 3 cells? I have A2 = 1067035C03 I need B2 = 1067, C2 = 035, D2 = C03 Thank you. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Split 10 alphanumerics into 3 cells
mike:
when you configure the text to columns, all you have to do is select the text radio button instead of the general button, for the specific column on step 3 of the wizard, and it should do this for you. -- Gary Keramidas Excel 2003 "Mike H" wrote in message ... Vic, Just noticed you'll lose the leading zero in C2 so custom format that cell as 000 to get it back "Mike H" wrote: Vic Data - Text to Columns - Fixed width and set the breaks OK Mike "Vic" wrote: What is the formula to split 10 alphanumerics into 3 cells? I have A2 = 1067035C03 I need B2 = 1067, C2 = 035, D2 = C03 Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup functions which could not recognise similar alphanumerics | Excel Worksheet Functions | |||
| How to Split the contents of cells across multiple cells | New Users to Excel | |||
| Split cells | Charts and Charting in Excel | |||
| Ignore Non-Alphanumerics When Comparing Text | Excel Worksheet Functions | |||
| Average using alphanumerics | Excel Worksheet Functions | |||
Linear Mode
