Related:
- Returning text from one of several columns
- Display two columns in data validation list but return only one - Guide
- Excel copy column from one sheet to another automatically - Guide
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- If two cells match return value from third excel ✓ - Excel Forum
- How to re/name a cell if another cell contains X ✓ - Excel Forum
2 responses
kaiyasit
Posts
30
Registration date
Sunday August 9, 2009
Status
Member
Last seen
April 20, 2010
12
Aug 14, 2009 at 10:08 PM
Aug 14, 2009 at 10:08 PM
use this formula in D1,D2.....Dn
=A1 & B1 & C1
=A1 & B1 & C1