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

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

Split column contents (de-concantenate) 7
Keeping Leading Zeros; How Please ? 2
Leading Zeros; How to Keep ? 2
Concantenate which keeps bold of some parts. 5
Text and Numeric lookup 5
Transferring only certain rows to seperate worksheet 8
Spliting cell contents into two cels based on location of "&" 3
Excel Concatenate with line breaks but ignore blank cells 3

Back
Top