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
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