Address must be 18 characters long
 

Hi all again

I need the address to be 18 characters long i.e. if the address is over 18
characters then chop it, if its under, then add spaces

Is this possible?

Thanks as always

Derek

Address must be 18 characters long
 

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

This will add spaced at the end

if you want spaces in front
=right(rept(" ",18)&a1,18)

--
Wag more, bark less


"Derek M" wrote:

Hi all again

I need the address to be 18 characters long i.e. if the address is over 18
characters then chop it, if its under, then add spaces

Is this possible?

Thanks as always

Derek

Address must be 18 characters long
 

that second formula would result in the last 18 characters of the address if
A1 was already longer than that.

=left(rept(" ",max(0,18-len(a1)))&a1,18)



"Brad" wrote in message
...
=left(a1&rept(" ",18),18)

This will add spaced at the end

if you want spaces in front
=right(rept(" ",18)&a1,18)

--
Wag more, bark less


"Derek M" wrote:

Hi all again

I need the address to be 18 characters long i.e. if the address is over
18
characters then chop it, if its under, then add spaces

Is this possible?

Thanks as always

Derek

Address must be 18 characters long
 

Fantastic, thanks guys

"Steve Dunn" wrote:

that second formula would result in the last 18 characters of the address if
A1 was already longer than that.

=left(rept(" ",max(0,18-len(a1)))&a1,18)



"Brad" wrote in message
...
=left(a1&rept(" ",18),18)

This will add spaced at the end

if you want spaces in front
=right(rept(" ",18)&a1,18)

--
Wag more, bark less


"Derek M" wrote:

Hi all again

I need the address to be 18 characters long i.e. if the address is over
18
characters then chop it, if its under, then add spaces

Is this possible?

Thanks as always

Derek