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

  • Thread starter Thread starter richprince
  • Start date Start date
R

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
 
=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."
 
Back
Top