We have lots of ideas. But first you have to tell us what's in the cell. The
best way is to give a few examples of the cell's contents and the format you
want to see.

However, formatting is for numbers. If you have text in the cell (like
"first letter"), you can't format text.

Regards,
Fred.

"Jon" wrote in message
...
I would like to update the format of a cell as follows:

first letter + space + next four digits + remaining digits

Any ideas?