Adding a space

E

eddie57

I have a sentence in field A1 and a number in field A2. The formula I am
using is =A1 & A2. This is working but there is no space in between A1
and A2. How can I add a space? Any help is appreciated.

E
 
R

Rick Rothstein \(MVP - VB\)

I have a sentence in field A1 and a number in field A2. The formula I am
using is =A1 & A2. This is working but there is no space in between A1
and A2. How can I add a space? Any help is appreciated.
Click to expand...

Just concatenate it in like any other text...

=A1&" "&A2

Rick
 
R

Ron Coderre

The simple answer is:

=A1&" "&A2

Note that the above formula will return the numeric value in General format.

Example:
A1: "The price is:"
A2: 100.1..........Formatted as dollars, that would display as: $100.10

Howver, the above formula would disply: The price is: 100.1

To effect formatting, use this kind of formula:
=A1&" "&TEXT(A2,"$0.00")
Now the example would display as: The price is: $100.10

Does that help?
***********
Regards,
Ron

XL2003, WinXP
 
Top