If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to add a leading space to an existing text field?
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 |
#2
|
|||
|
|||
How to add a leading space to an existing text field?
=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." richprince wrote: 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 |
Thread Tools | |
Display Modes | |
|
|