# How to add a leading space with a format string?

I am converting centimeters to American Feet/Inches in a single column and I would like to obtain a properly formatted and *correctly aligned* text. E.g.

```
480 16' 7"
551 18' 11"
```

I am doing the cm/ft-in conversion in a formula and then converting and concatenating to text, with something like the following:

```
=TEXT(ROUND(G12/30.48),"##")&"' "&TEXT(ROUND(MOD(G12,30.84)/2.54),"##")&CHAR(34)
```

However, I lose the alignment in the inch part. To get the "inches" part properly aligned, I would need to insert a leading space when I convert the result to text, but I cannot find out what the the proper formatting string would be. I know I can insert leading zeros' with "00" but I cannot find the equivalent for spaces. Perhaps such a string does not exist?

Thanks for the help.

P.S. I can roll out my own IF function, of course, but the formula would become even uglier than it is already.

The second occurrence of the foot in your formula is wrong (twisted).