From: RobertG on 18 May 2010 14:04 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. From: Gary''s Student on 18 May 2010 14:09 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. From: hmsawyer on 18 May 2010 14:11 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. From: RobertG on 18 May 2010 14:13 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.  |  Pages: 1 Prev: Merging reportsNext: Formula returned instead of result