Thread: Concatenate
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Concatenate

Assuming source data in A1 and B1,
In C1: =A1&" "&B1

Or, perhaps better with a TRIM to remove any possible extraneous white
spaces in the source data, in C1: =TRIM(A1&" "&B1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Nadeem" wrote:
When I concatenate text from two cells, the texts get joined together. i want
to insert a space between the two text strings. Any ideas?