Thread: CONCATENATE
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Sloth
 
Posts: n/a
Default CONCATENATE

CONCATENATE means to join multiple strings together to form one long string.

Example:
A1 John
A2 Smith
A3 =CONCATENATE(A2,", ",A2)

A3 equals "Smith, John" which is the combination of three text strings
"Smith", ", " and "John".

It is better to use & to join text strings

Example:
A3 =A2&", "&A1

"countrygirl0712" wrote:

Would someone explain to me in plain english what "concatenate" means? Thank
you for explaining this to me.