Concetenate function

This query is : Resolved 

03 October 2013 in excel how to use concetenate function.

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





You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Join CCI Pro
CAclubindia's WhatsApp Groups Link


Similar Resolved Queries




Unanswered Queries