Concetenate function
This query is : Resolved
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
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
03 October 2013
Right!
https://office.microsoft.com/en-in/excel-help/concatenate-function-HP010062562.aspx
Thanks!!
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
Click here to login now
Similar Resolved Queries
Unanswered Queries
- STCG....................................................
- Supply through E-commerce Operators
- Sales return eway bill
- AMOUNT RECEIVED UNDER COMPULOSRY ACQUISITION OF AGRICULTURAL LAND
- TAN for Partnership
- Relief u/s Section 89
- GST Registration Horse racing
- Section 43B(h) – MSME Invoice Paid Before Year End but After 45 Days
- Taxation on LTCG for property sold after 24JUL2024
- Is E Way Bill Valid If Transport ID Not Mentioned in PART A But Vehicle details mentioned in PART B
- Section 54F - Exemption on LTCG in 2026 for HP purchased in 2023
- Sales amount in Gstr1
- CG after sale of flat
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
- Annexure B utility for GST Refund
- Tax amount diff in Gstr1 and 3B in tax compare reports
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
