=a1&text(a2,"#,##0")&a3

Same kind of things for dates, currency--anything that needs to be formatted.

PFLY wrote:

How do Concatinte: Cell A1: Better Cell A2: 1,545 and Cell A3: Test -
to display as "Better1,545Test"? Everytime i try this it loses the comma and
shows as "Better1545Test."

--

Dave Peterson