View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] jazzym31@hotmail.com is offline
external usenet poster
 
Posts: 2
Default How do I write a script to add space between numbers in a column?

I have a file with a column that contains numbers that have six digits. I
need to add a space between the last two digits in this very long column of
numbers. Is there an efficient way of doing this? Example: 120100 needs to
be 1201 00