Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining Letters and Numbers
I have 2 values that i convert into a specified letter and the other a
number. I need to take those 2 cells and combine them into their respective letter combinations. For example. Data imput one produces A and 4 in 2 different cells. I need to have a new cell that combines these into A4 As another example, Input1 Input 2 Output1 Output2 6 2234 A 3 I need thoser 2 outputs to combine into one cell as A3 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining Letters and Numbers
=Output1&Output2
Replace Outputs by cell references, like A3&A4 -- Kind regards, Niek Otten Microsoft MVP - Excel "dippy" wrote in message ... I have 2 values that i convert into a specified letter and the other a number. I need to take those 2 cells and combine them into their respective letter combinations. For example. Data imput one produces A and 4 in 2 different cells. I need to have a new cell that combines these into A4 As another example, Input1 Input 2 Output1 Output2 6 2234 A 3 I need thoser 2 outputs to combine into one cell as A3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count only Letters in cells that contain both letters and numbers | Excel Worksheet Functions | |||
letters for numbers | Excel Discussion (Misc queries) | |||
Sorting - cells containing numbers, numbers and letters | Excel Discussion (Misc queries) | |||
create self-generating numbers with letters and numbers | Excel Discussion (Misc queries) | |||
corresponding numbers and letters | Excel Discussion (Misc queries) |