This would not be a formatting issue, but if the data is same throughout the
column you could parse the data and concatenate it to look the way you want
it to.

The following formula parses the data in A1 an inserts spaces after the 3rd
and 7th characters:

=LEFT(A1,3)&" "&MID(A1,4,3)&" "&RIGHT(A1,3)
--
Kevin Backmann


"5631" wrote:


How should I format a cell to see 'aaa 1234 bbb' if a cell value is
'aaa1234bbb' ?


--
5631
------------------------------------------------------------------------
5631's Profile: http://www.excelforum.com/member.php...o&userid=33022
View this thread: http://www.excelforum.com/showthread...hreadid=528465