Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have a bunch of numers written in an excell sheet that I want to be able to seperate the first two letters and move the rest to collumn B. Ex) Column A Column B 37001-03501 38001-03502 39001-03503 40001-03504 would become A B 37 001-03501 38 001-03502 39 001-03503 40 001-03504 Thank you very much for any help with this, Jordan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
modify linked cells without breaking link | Excel Discussion (Misc queries) | |||
split text in one cell into multiple cells without breaking the wo | Excel Worksheet Functions | |||
breaking text in one cell into two cells | Excel Discussion (Misc queries) | |||
Breaking a Cell | Excel Worksheet Functions | |||
Breaking a word by each alphabet and inputing it in different cells | Excel Programming |