How to Copy Text to Fixed Length with leading Spaces ?

[tmb]

I need to copy the text data in one cell to another cell and end up with
Fixed Length Ascii.

Example:

A1 = XYZ
B1 = --XYZ

Where -- are actually either Spaces

thanks for any help

 

[Bob Phillips]

=IF(LEN(A1)<5,REPT(" ",5-LEN(A1)),"")&A1

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Hi

Try =REPT("--",4-LEN(A1))&A1

Regards
Peter

 

[Guest]

Sorry

=REPT("-",5-LEN(A9))&A9

Regards
Peter

 

[Dave Peterson]

One more:

=RIGHT(REPT("-",5)&A1,5)

Change the dash to a space character.

 

[Earl Kiosterud]

It appears, from another post of yours, that you're going to use this to
create a fixed-length file. If your data is text, you'll want padding on
the right, most likely, but if numeric, you'll want left.

There's a non-macro way to do all of this. Look at
http://www.smokeylake.com/excel/textfiles.htm. And there are other posts on
this subject in these newsgroups you should look at.

 

[tmb]

thanks Earl, your probably right. I'll double check the spec.