Forum Discussion
EXCEL
Hello everyone! I need your help formatting rows in Excel.
I have a large file with three rows. The content of the rows is text.
These three rows must be combined to form one row in the following format:
first name,[space]last name,[space]email address,
What formula can I use to do this?
I've tried a lot, but Excel always gives me two [space|space] instead of one space.
Thank you! I'm really looking forward to your answers!
1 Reply
Let's say first name is in A2 and down, last name in B2 and down, and email address in E2 and down. In the column where you want to combine them, in row 2:
=TEXTJOIN(", ", TRUE, A2, B2, E2)
Fill down.
