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?
FlashDarkness
Favorite Answer
=a1 & left(c1,1) & " " & b1 & " -" & right(c1,3)
works if column c always has exactly 4 characters
Anonymous
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
DS
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.