How to add a leading space to an existing text field?

[richprince]

I have 2 columns of data that I want to concatenate, however, I need a space
to separate the second column for readability. Example: column 1 (100)
column 2 (n. baker st.) - result: 100 n. baker st.

Excel 2007

 

[Dave Peterson]

=a1&" "&b1

If you ever decide you want to format the number (like a date or money or time):

="Your payment is due on: " & text(a1,"mmmm dd, yyyy")
& ". Please include: " & text(b1,"$#,##0.00") & " payable to the IRS."