[Solved] Append Text onto end of another cell's text

toekneebullard · Post by **toekneebullard** » Tue Jul 01, 2008 3:46 pm

OK, so I have a list of System Codes (i.e. 4568) along side Market names (i.e. Comcast/Lake Park, GA). The SysCodes and Market Names are in separate columns. What I would like to do is consolidate that data, so the SysCode is at the end of the Market Name with a space in between them. (i.e. Comcast/Lake Park, GA 4568)

I've been looking through the consolidate function, but everything seems to be number based.

Post by **acknak** » Tue Jul 01, 2008 4:55 pm

You can use the CONCATENATE function, but it's easier to use the concatenate operator: &

A1: Comcast/Lake Park, GA
A2: 4568
A3: =A1 & " " & A2 --> Comcast/Lake Park, GA 4568

toekneebullard · Post by **toekneebullard** » Tue Jul 01, 2008 5:00 pm

Thanks for your help.

[Solved] Append Text onto end of another cell's text

[Solved] Append Text onto end of another cell's text

Re: Append Text onto end of another cell's text

Re: [Solved] Append Text onto end of another cell's text