I have long lists of information that have been downloaded from a serve
and it needs to be formatted in a specific way. The information i
each cell is consistant in size but requires spaces at specific spots.
examples:

040001000000000 before change
04 0001 00 000 00 00 after change


040005SW0010000 before change
04 0005 SW 001 00 00 after change

I know this can be done, but I don't seem to be able to find the righ
way to write the macro to make this work.

The Cell Format dosen't change the information either.

Any help is appreciated.

Thank

--
Message posted from http://www.ExcelForum.com