View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jordan Jordan is offline
external usenet poster
 
Posts: 144
Default breaking a cell into two cells via VBA program

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