ExcelBanter - Text entered in two separate cells appear as one word in another

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Text entered in two separate cells appear as one word in another (https://www.excelbanter.com/new-users-excel/240274-text-entered-two-separate-cells-appear-one-word-another.html)

LIZZIE

Text entered in two separate cells appear as one word in another

Text entered in two separate cells eg. A1 TOM B1 HARRIS how do I get these
two words to appear as TOMHARRIS in Cell C1

Eduardo

Text entered in two separate cells appear as one word in another

Hi,
=A1&B1

if you need a comma in between

=A1&","&B1

if this helps please click yes, thanks

"lizzie" wrote:

Text entered in two separate cells eg. A1 TOM B1 HARRIS how do I get these
two words to appear as TOMHARRIS in Cell C1

All times are GMT +1. The time now is 12:13 PM.