| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split the cells
Hi
is there any way to split the following cells using a formula, so the last three numbers are separated from the number? e.g. Column A Column B 0C 264 0C 265 0C 267 0C264 0C265 0C267 Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Split the cells
as long as it is consistant and you want to split the first two characters
into assumes your concatinized item is in column A column B and the last 3 characters into column C one way is column B =left(a1,2) column C =right(a1,3) "da" wrote: Hi is there any way to split the following cells using a formula, so the last three numbers are separated from the number? e.g. Column A Column B 0C 264 0C 265 0C 267 0C264 0C265 0C267 Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Split the cells
Thank you. It worked.
"pmartglass" wrote: as long as it is consistant and you want to split the first two characters into assumes your concatinized item is in column A column B and the last 3 characters into column C one way is column B =left(a1,2) column C =right(a1,3) "da" wrote: Hi is there any way to split the following cells using a formula, so the last three numbers are separated from the number? e.g. Column A Column B 0C 264 0C 265 0C 267 0C264 0C265 0C267 Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split value into 2 cells | Excel Discussion (Misc queries) | |||
| How to Split the contents of cells across multiple cells | New Users to Excel | |||
| Split cells | Charts and Charting in Excel | |||
| Split Cells | Setting up and Configuration of Excel | |||
| split cells | Excel Discussion (Misc queries) | |||
Linear Mode
