Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I have a string of numbers 00633.84010.12740.0000.10101 that I need to break
out into the separate components. |
#2
![]() |
|||
|
|||
![]()
Is the string of numbers always 5 numbers, a dot, 5 numbers, a dot,
etc? If it's *always* in that format you can use a MID() function. If the separate components are between dots but irregularly spaced it becomes trickier. If it's the easy scenario, and supposing your string is in cell A1, try =MID(A1,1,5) =MID(A1,7,5) =MID(A1,13,5) etc |
#3
![]() |
|||
|
|||
![]()
Hi Julia,
If you try Data Text to Columns and follow the options, this may be what you are after. Regards Graham julia wrote: I have a string of numbers 00633.84010.12740.0000.10101 that I need to break out into the separate components. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Count number of shaded cells | Excel Discussion (Misc queries) |