Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
MS Excel text handling question?
I want to combine text strings from different cells to create a new string:
A B C
1 John Doe John Doe
2. Mary Roe Mary Roe
I know there's a way, did it years ago; something like "A1"+"B1" as the formula for C1.
1 Answer
- 3 years ago
You're looking for the function concat. If you want to joint the text from A1, B1, and C1 (lets say), it would be
=CONCAT(A1, B1, C1)
Though keep in mind that the function does not add spaces, and so you will need to add a space after each cell youre joining together.