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