MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel cell formats


Posted by Adrian Evans on August 15, 2001 11:39 PM

How do I merge or format cells into an email address??

e.g.Simon . Hadwin @hotmail.com

each of these peices of text are in a seperate cell (simon in one cell, the dot in another etc)


Posted by anno on August 16, 2001 12:55 AM

adrian
assuming all the pieces of text are in cells A1 to G1, use this: =A1&B1&C1&D1&E1&F1&G1.

Posted by anno on August 16, 2001 1:01 AM

adrian
assuming the pieces of text are in cells A1 to G1, use this formula: =A1&B1&C1&D1&E1&F1&G1.
You appear to have spaces in your example which is unusual for an email address, but assuming they are meant to be there, use =A1&" "&B1&" "&C1&" "&D1&E1&F1&G1