Insert 3 Spaces Between Number

[muhammad susanto]

hi all...

how to make 3 spaces between number below :
count of number = 18
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Data
[/TD]
[TD]After formula
[/TD]
[/TR]
[TR]
[TD]197906141999031001
[/TD]
[TD]19790614 199903 1 001
[/TD]
[/TR]
[TR]
[TD]196206031981091002
[/TD]
[TD]19620603 198109 1 002
[/TD]
[/TR]
</tbody>[/TABLE]

anybody help me, thanks a lot..

.sst

 

[Rick Rothstein]

Give this formula a try...

=REPLACE(REPLACE(REPLACE(A1,16,0," "),15,0," "),9,0," ")

 

[muhammad susanto]

woww.....very quckly!!! thank you Rick.