Adding a space at the end of a text string

[TOFW]

I need to add a single space to the end of a text string in a column of numbers of varying lengths. (Find and replace is somewhat limited)
Thanks for that which works for any length of number. I forgot to mention that some cells have no number and do not require a space!
What I'm actually trying to achieve but perhaps looking at the problem the wrong way is as follows
column 1 has a house number
column 2 has a street
I can use the following
=CONCATENATE(A1," ",A2)which works fine apart from it adds a space to the front of the result when column 1 has no number
eg
Column 1 is 88
Column 2 is Hill Street

Formula returns 88 Hill Street

Column 1 is Empty
Column 2 is Hill Street

Formula returns (space)88 Hill Street
Which means the address result is not aligned
Any ideas to help?
This message was edited by TOFW on 2002-09-19 02:47

 

[DonkeyOte]

=A1 & " "

 

[TOFW]

Thanks for that which works for any length of number. I forgot to mention that some cells have no number and do not require a space!
What I'm actually trying to achieve but perhaps looking at the problem the wrong way is as follows
column 1 has a house number
column 2 has a street
I can use the following
=CONCATENATE(A1," ",A2)which works fine apart from it adds a space to the front of the result when column 1 has no number
eg
Column 1 is 88
Column 2 is Hill Street

Formula returns 88 Hill Street

Column 1 is Empty
Column 2 is Hill Street

Formula returns (space)88 Hill Street
Which means the address result is not aligned
Any ideas to help?

 

[DonkeyOte]

This can simply be avoided using an IF...

IF(A1="",B1,A1&" "&B1)

 

[TOFW]

Thanks for your help I'll get to grips with formulas eventually!!