Concetenate function

This query is : Resolved

Report Abuse Follow Query Ask a Query

prashant

prashant (Querist)
Follow

03 October 2013 in excel how to use concetenate function.

CA Vijeta Verma

CA Vijeta Verma (Expert)
Follow

03 October 2013 Concatenate function is used to join multiple text,numeric strings generally upto 255 strings.
EX- if you want to apply concatenate here

A B C D
1 xyz 140 india
2 abc 123 japan
now if you want to apply concatenate with a view to see the combined values xyz,140,india in a single cell
type-
=concatenate(B2,"",C2,"",D2)
Where b2,c2,d2 are your selected cells whose value you want to combine
inverted commas are spaces