Inserting a specific number of blank spaces

[itldp]

Hi all!

is there any way i can write one formula to insert a specific spaces after text in a cell?

probably makes no sense, so here is my example:

HAIR
FASHION

i need to make sure that the text occupies 15 spaces so that when it is exported into a text file, the columns are lined up correclty. therefore, i need to add 11 spaces after the word hair and 8 spaces after the word fashion.

I know to use the length function, but then what? please let me know if you need more info.

Thanks! :wink:

 

[Aladin Akyurek]

One way...

=LEFT(A1&REPT(" ",15),15)

 

[Egress1]

Hi all!

is there any way i can write one formula to insert a specific spaces after text in a cell?

probably makes no sense, so here is my example:

HAIR
FASHION

i need to make sure that the text occupies 15 spaces so that when it is exported into a text file, the columns are lined up correclty. therefore, i need to add 11 spaces after the word hair and 8 spaces after the word fashion.

I know to use the length function, but then what? please let me know if you need more info.

Thanks! :wink:

YourNewString = "HAIR"
Using The LEN function to determin how much less the text is from 15

YourPad = SPACE(15 - LEN("HAIR"))
YourNewString = YourNewString & YourPad

 

[itldp]

thanx for the replies!!

now i got my program working :D

 

[ramrajesh0205]

thanx for the replies!!

now i got my program working :D

How itz working itz not working for me....