I have a requirement to have meet a specified field length. For example if
name field length is 7 and the name entered is SAM; what functions
(operations, marcos, vb scripts) are available in excel that can
automatically add either leading or trailing spaces to make the length equal
to 7?

=A1&REPT(" ",7-LEN(A1))

"Sharon" wrote:

I have a requirement to have meet a specified field length. For example if
name field length is 7 and the name entered is SAM; what functions
(operations, marcos, vb scripts) are available in excel that can
automatically add either leading or trailing spaces to make the length equal
to 7?

=LEFT(" ",7-LEN(A1))&A1
there are 7 spaces between opening and closing "
or
=A1&LEFT(" ",7-LEN(A1))

But you now have SAM in cole column and SAM____ in another
You could use copy followed by Paste Special with Values specified to make
the first column unneeded but this would be after all data was entered.

If you want the change to happen on the fly, please post Q to the
Programming group

best wishes

--
www.stfx.ca/people/bliengme


"Sharon" wrote:

I have a requirement to have meet a specified field length. For example if
name field length is 7 and the name entered is SAM; what functions
(operations, marcos, vb scripts) are available in excel that can
automatically add either leading or trailing spaces to make the length equal
to 7?

A couple mo

=right(rept(" ",7)&a1,7)

=left(a1&rept(" ",7),7)



Sharon wrote:

I have a requirement to have meet a specified field length. For example if
name field length is 7 and the name entered is SAM; what functions
(operations, marcos, vb scripts) are available in excel that can
automatically add either leading or trailing spaces to make the length equal
to 7?

--

Dave Peterson