Thread: Excel file
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] jazzym31@hotmail.com is offline
external usenet poster
 
Posts: 2
Default Excel file

I have a file with a column that has six digits in the column. The file is
extremely long and I need to add a space beetween the last two digits in the
column,. Example: 120100 needs to become 1201 00, and so on. Is there an
effieicient way of doing this?