Discussion
In MS Excel, what does the CONCATENATE function (or the & operator) do?
Answer: B
Correct answer: Joins several text values into one
CONCATENATE joins text values end to end, and the ampersand does the same more briefly: =A1&" "&B1 joins a first and last name with a space between. The space must be supplied explicitly, since nothing is added automatically. Newer versions provide CONCAT and TEXTJOIN. TEXTJOIN is the more capable, taking a delimiter and an option to ignore empty cells, so a list can be assembled without stray separators. The reverse operation is Text to Columns on the Data tab, which splits one column into several at a delimiter or at fixed widths - the second option here. Flash Fill, Ctrl + E, does the same by example and is often quicker. The related text functions are worth knowing: TRIM removes surplus spaces, UPPER, LOWER and PROPER change case, LEFT, RIGHT and MID extract parts, and LEN counts characters.
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development