How do I concatenate three text only cells and still retain the formatting?

For example: 001002 Yamaha Description xxxxxxxx

Thanks for your help in advance.