Question
Download Solution PDFWhat is the purpose of the "CONCAT" function?
This question was previously asked in
OSSC Junior Stenographer, Junior Typist (Prelims) Official Paper (Held On: 09 Feb, 2025)
Answer (Detailed Solution Below)
Option 4 : To combine multiple text strings into one
Free Tests
View all Free tests >
OSSC Junior Stenographer, Store Keeper, Junior Clerk Full Test 1
2.2 K Users
150 Questions
150 Marks
150 Mins
Detailed Solution
Download Solution PDFThe correct answer is To combine multiple text strings into one.
Key Points
- The "CONCAT" function is used to join multiple text strings into one single string.
- This function is particularly useful for merging values from different cells into one cell in applications like Excel or Google Sheets.
- It automatically concatenates text, numbers, or a combination of both without adding spaces unless explicitly provided.
- To include spaces, you can specify them as separate arguments, e.g., CONCAT("Hello", " ", "World").
Last updated on May 16, 2025
-> The OSSC Junior Stenographer Mains Merit List has been released on 16th May 2025.
-> The Mains Written Examination 2024 was held on 12th April 2025.
->Earlier, OSSC Junior Stenographer 2025 Notification was released for 67 stenographer vacancies.
->The application window is open from 4th April 2025 till 3rd May 2025.
-> Candidates must go through the OSSC Odisha Junior Stenographer Previous Year Papers to understand the trend of the exam.