Excel Function - Adding Semi-Colons to Separate Cells

**roundupriverranch** · 03-04-2012, 07:59 PM

I am interested in essentially doing the reverse of text to columns, combining three columns into one, separating the fields by a semi-colon. IE: taking three columns, first name, last name, and email address, and then combining to appear in one cell as follows - first name; last name; email address.

I found the following equation online - =A1&IF(B1<>""," "&B1,"")&" "&C1 - to help be combine the cells. I am unsure, however, how to add semi-colons between the fields. Is someone able to provide assistance or clarification as to how to do this?

Thank you in advance.

**Special-K** · 03-04-2012, 08:23 PM

Try
=A1&IF(B1<>"","; "&B1,"")&"; "&C1

**DGagnon** · 03-04-2012, 09:36 PM

or even easier you can do this: =A1&";"&B1&";"&C1

**DGagnon** · 03-16-2012, 10:26 PM

Is your issue resolved? If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.