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
How do I concatenate two cells in Excel?
I have two cells, both containing text, in different areas of the same excel sheet. I want to concatenate them into another cell, but when I type the formula
=concatenate (b7 , f25) I only see my formula, not its result. All 3 cells are formatted as Text. Any ideas?
3 Answers
- ?Lv 77 years agoFavorite Answer
"All 3 cells are formatted as Text."
The text format is preventing the formula from being parsed. Set it back to General (or whatever format you need), and re-enter the formula.
- Donut TimLv 77 years ago
You have a "space" between your b7 and the comma, and also after the word concatenate. Remove them and the formula may work.
. .
- Anonymous7 years ago
Put & sign between two cell address i.e. =CONCATENATE(A36&B36)
