Concetenate function


This query is : Resolved 

(Querist)
03 October 2013 in excel how to use concetenate function.

Profile Image

Guest

Profile Image

Guest (Expert)
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

@VaibhavJ (Expert)
03 October 2013 Right!


https://office.microsoft.com/en-in/excel-help/concatenate-function-HP010062562.aspx


Thanks!!


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



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
Featured ARTICLESHIP 17 November 2026
Associate/ Article Trainee

M/s. A V C & Co.

New Delhi

CA Inter

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details
Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details