Adding a space

[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

 

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

Just concatenate it in like any other text...

=A1&" "&A2

Rick

 

[Guest]

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

 

[Guest]

=CONCATENATE(A1," ",A2)