banner_ad

Concetenate function

This query is : Resolved 
Profile Image

Profile Image

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

CA Vijeta Verma

Profile Image

CA Vijeta Verma (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
Profile Image

@VaibhavJ

Profile Image

@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


CCI Pro
Join the CA Students WhatsApp Community for ICAI Updates, Trending Courses & Notes!


Similar Resolved Queries


loading


Unanswered Queries


banner

Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Follow us
add to google news



Answer Query



Quick Links



Browse by Category




Latest Job Openings

View all
Company
22 May 2026
Sr. Financial Analyst - Consolidation

Search Synergy

Mumbai

CA

View Details
Company
09 May 2026
Audit Manager

Kanna and Associates

Coimbatore

CA Inter

View Details
Company
ARTICLESHIP 23 May 2026
Article Assistants

Acupro Consulting

Gurgaon

CA Inter

View Details
Company
14 May 2026
Financial Analyst - Remote Finance Expert

HiringBridge

Ahmedabad

CA

View Details
Company
22 May 2026
U.S. Financial Reporting & Consolidation Manager

Karia Overseas

Ahmedabad

CA

View Details
Company
ARTICLESHIP 05 May 2026
ARTICLED ASSISTANT

JS ADVISORS

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 15 May 2026
ARTICLE ASSISTANT, TRAINEE AND PAID ASSISTANT

YOGESH KAPOOR AND ASSOCIATES

New Delhi

B.Com

View Details
Company
23 May 2026
Article Assistant

Geeta Manchanda & CO.

New Delhi

CA Inter

View Details