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

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
 
D

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Keeping Leading Zeros; How Please ? 2
Leading Zeros; How to Keep ? 2
Concantenate which keeps bold of some parts. 5
Excel Concatenate with line breaks but ignore blank cells 3
Spliting cell contents into two cels based on location of "&" 3
converting line-delimited text into cells 2
Transferring only certain rows to seperate worksheet 8
Adding a leading space to a numeric column 3

Top