How to add spaces to the both sides of text in a cell

[sami9]

I need to add spaces in the beginning and end of a text. e.g Text is John. I need 4 spaces before J and 7 spaces after n. How to accomplish this.

 

[mohadin]

I see have you replace ; with , in your

H5=[COLOR=#333333]REPT(" ",4)&G5&REPT(" [/COLOR]",7)

 

[sami9]

if you data in G5 and the result in H5 then

H5=[COLOR=#333333]REPT(" ";4)&G5&REPT(" ";7)[/COLOR]

Sorry my data was in H5. But I tried the above by keeping data in G5 and formula is H5 but still it is not working.

 

[mohadin]

If you data in H5 then

=[COLOR=#333333]REPT(" ",4)&H5&REPT(" ",7)[/COLOR]

 

[Peter_SSs]

Thanks.

=REPLACE(REPT(" ",11),5,0,A1)

This one worked for me. I needed formula and it served my purpose

You are very welcome.

 

[sami9]

if you data in G5 and the result in H5 then

H5=[COLOR=#333333]REPT(" ";4)&G5&REPT(" ";7)[/COLOR]

After many hit and trial, the following worked.
=REPT(" ",4)&G5&REPT(" ",7)

Thanks

 

[mohadin]

You are very well come
And thank you for replay