Hope this is easy
How do I combine an alpha character from one cell with a numeric value in
another cell and display the result in a 3rd cell like this: Cell A1 = B Cell B1 = 2 Cell C1 should equal B2 Not the sum of the cells, just the actual value "B2". Thanks. |
Hope this is easy
In C enter the formula:
=A1 & B1 -- Gary''s Student - gsnu201003 "RobertG" wrote: How do I combine an alpha character from one cell with a numeric value in another cell and display the result in a 3rd cell like this: Cell A1 = B Cell B1 = 2 Cell C1 should equal B2 Not the sum of the cells, just the actual value "B2". Thanks. |
Hope this is easy
I'm pretty sure that =A1&B1 will get you what you need.
"RobertG" wrote: How do I combine an alpha character from one cell with a numeric value in another cell and display the result in a 3rd cell like this: Cell A1 = B Cell B1 = 2 Cell C1 should equal B2 Not the sum of the cells, just the actual value "B2". Thanks. |
Hope this is easy
Thank you. See I knew it would be easy.
"Gary''s Student" wrote: In C enter the formula: =A1 & B1 -- Gary''s Student - gsnu201003 "RobertG" wrote: How do I combine an alpha character from one cell with a numeric value in another cell and display the result in a 3rd cell like this: Cell A1 = B Cell B1 = 2 Cell C1 should equal B2 Not the sum of the cells, just the actual value "B2". Thanks. |
All times are GMT +1. The time now is 06:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com