Try:
=LEFT(A1,15)&"* *"&MID(A1,16,17)&"* *"&MID(A1,34,19)&"* *"&MID(A1,53,25)&"*
*"&MID(A1,85,18)&"* *"&RIGHT(A1,16)


"RebLan" wrote:

Okay....this is what i need help on. These multiple lines in one cell is
throwing me off. If i make the multiple lines appear as a single text string
in one cell, i still have spacing issues.

(A1)

ATM ID: Example
Project ID: 12345
Project Name: HELP
Site Name: Company Name
Model: 2345e EF
SN: Not Assigned

I need it to look like this all in one cell, due to a system upload.

ATM ID: Example**Project ID: 12345**Project Name: HELP**Site Name: Company
Name**Model: 2150e EF**SN: Not Assigned

Please HELP!!!

Thanks