Thread: Adding a space
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Adding a space

=CONCATENATE(A1," ",A2)

"eddie57" wrote:


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




--
eddie57