Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate Numers / Text (Special)
- I need to concatenate three cells each containing specific info:
1st cell is a letter (ie. "A", "B", etc.) 2nd & 3rd Cells are two digit numbers (ie. 01, 02....10,11)-(format is custom 00) I need the combination to concatenate and show as follows: A0105, B1106, H0209, etc. Please help, I am beginning to think that this is an impossible task. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate Numers / Text (Special)
=a1&text(b1,"00")&text(c1,"00")
or you could do the arithmetic first: =a1&text((b1*100)+c1,"0000") Teddy-B wrote: - I need to concatenate three cells each containing specific info: 1st cell is a letter (ie. "A", "B", etc.) 2nd & 3rd Cells are two digit numbers (ie. 01, 02....10,11)-(format is custom 00) I need the combination to concatenate and show as follows: A0105, B1106, H0209, etc. Please help, I am beginning to think that this is an impossible task. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate Numers / Text (Special)
try this
assumed cell A1 has Letter B1 & B2 has numbers =A1&TEXT(B1,"00")&TEXT(B2,"00") On Dec 24, 9:30*pm, Teddy-B wrote: - I need to concatenate three cells each containing specific info: 1st cell is a letter (ie. "A", "B", etc.) 2nd & 3rd Cells are two digit numbers (ie. 01, 02....10,11)-(format is custom 00) I need the combination to concatenate and show as follows: A0105, B1106, H0209, etc. Please help, I am beginning to think that this is an impossible task. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste Special text or Unicode Text | Excel Discussion (Misc queries) | |||
how to converting numers to text | Excel Worksheet Functions | |||
Substituting letters for numers | New Users to Excel | |||
Giving numers value to selections | Excel Discussion (Misc queries) | |||
Using Concatenate function to generate text in Text Box | Charts and Charting in Excel |