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
Excel Concatenate Cell Format Question?
OK, here's a tricky one for you experts. I have a spread with over 90,000 unique IDs. I will use line 1 as an example. CELL A1 = 48, CELL B1 = 100, CELL C1 = ACAA. So now how do I Concatenate these values from this 48 100 ACAA (shown above) to this: 48A 100 -CAA? Is this even possible?
3 Answers
- FlashDarknessLv 61 decade agoFavorite Answer
=a1 & left(c1,1) & " " & b1 & " -" & right(c1,3)
works if column c always has exactly 4 characters
- Anonymous5 years ago
I would say the reason you get that because the cell is displaying general numbers. Don't know whether this will work but it's worth a try. Highlight the Cell ► Format ► Cell ► Number ► Change the setting to Currency
- 1 decade ago
You'll have to drop the first letter from C1 in order to get "-CAA" - there is no way to make it ignore that character.
If the first A can stay, use this formula:
=CONCATENATE(A1," ",B1," -",C1)
this will yield" 48 100 -ACAA"
just put *quote**space**quote* to make a space, and *quote**space**dash**quote* to make the dash.
add me to yahoo msgr if you need more help.
