Hi,

Just an idea: if its possible for the cell to get focus (not sure if
this is limited to forms?), you could then use the Instr function to
search out and replace a specific character with the five spaces.
Alternatively, could you combine cell.parse with a merge function?
Seems a long way round.....

Just shootin the breeze on this one, if I can get some code together,
will post it.

Cheers


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