Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy middle digits from one cell into another
I need to copy the middle digits of a number into another cell. i.e. if the
number were skl233ks03za, in cell A1, then I would need to copy only 33ks0 into cell D1. Does anyone know how to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy middle digits from one cell into another
What's the rule behind it, is it always starting with the 5th character
and is it always 5 characters long? If so =MID(A1,5,5) Regards, Peo Sjoblom Sharon R wrote: I need to copy the middle digits of a number into another cell. i.e. if the number were skl233ks03za, in cell A1, then I would need to copy only 33ks0 into cell D1. Does anyone know how to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
Copy Cell to Word ? | Excel Discussion (Misc queries) | |||
need to Copy or Move to active cell from specified range | Excel Discussion (Misc queries) | |||
How to Copy the value of a cell to any given cell | Excel Discussion (Misc queries) | |||
hpw do I logic test a cell then copy the row to diff. SS | Excel Worksheet Functions |