# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have copied and pasted a list of 16 participants from an email invite into excel and i want to create a list of participants in each cell. they are separated by the ; and i would like also to put their email address in a corresponding column . can anyone point me in the right direction
Solved by S. Q. in 16 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 23/05/2018 - 05:10
Hi
Excelchat Expert 23/05/2018 - 05:11
Hello
User 23/05/2018 - 05:11
hi
Excelchat Expert 23/05/2018 - 05:11
so you have a list of name separated by ; right
User 23/05/2018 - 05:11
yes
Excelchat Expert 23/05/2018 - 05:11
can you paste it on the right herre
User 23/05/2018 - 05:12
assuming you can see it
Excelchat Expert 23/05/2018 - 05:12
yes
Excelchat Expert 23/05/2018 - 05:13
Divakaran Namputh, Sujith Kumar this is 1 name right?
Excelchat Expert 23/05/2018 - 05:13
this is a one time activity right?
User 23/05/2018 - 05:13
brett, sujith kerry and yusef
User 23/05/2018 - 05:14
will just need to separate and possibly do in the future.
User 23/05/2018 - 05:14
i got the list of emails now i want to separate the names so i can make an easy list
Excelchat Expert 23/05/2018 - 05:14
Coles, Brett is 1 name?
User 23/05/2018 - 05:15
yes that is correct last name then first name
Excelchat Expert 23/05/2018 - 05:15
ok for this we need to saparate one by one 1st email with name since we know the saparater is ;..
Excelchat Expert 23/05/2018 - 05:16
excel has a feature called Text to column
User 23/05/2018 - 05:17
where would that be located
Excelchat Expert 23/05/2018 - 05:17
Excelchat Expert 23/05/2018 - 05:17
can you find it..
Excelchat Expert 23/05/2018 - 05:18
select delimited -> others(;) then click on ok
Excelchat Expert 23/05/2018 - 05:18
Excelchat Expert 23/05/2018 - 05:19
the result would look like this
Excelchat Expert 23/05/2018 - 05:19
are you getting it?
Excelchat Expert 23/05/2018 - 05:19
are you there
User 23/05/2018 - 05:20
yes - this produced a column each
Excelchat Expert 23/05/2018 - 05:20
ok now we will make it rows
User 23/05/2018 - 05:20
Excelchat Expert 23/05/2018 - 05:21
select all the column
User 23/05/2018 - 05:21
yes
Excelchat Expert 23/05/2018 - 05:21
cntrl+c
User 23/05/2018 - 05:21
yes
Excelchat Expert 23/05/2018 - 05:22
then select a cell right click paste special transpose
Excelchat Expert 23/05/2018 - 05:23
did you get it
User 23/05/2018 - 05:23
yes - can i do the same with the > symbols around the email?
Excelchat Expert 23/05/2018 - 05:23
exactly...
Excelchat Expert 23/05/2018 - 05:24
so select the entire column
Excelchat Expert 23/05/2018 - 05:24
then text to column -> delimeter->other(<)
User 23/05/2018 - 05:25
User 23/05/2018 - 05:25
Thank you
Excelchat Expert 23/05/2018 - 05:25
did you get this
Excelchat Expert 23/05/2018 - 05:25
Excelchat Expert 23/05/2018 - 05:26
please leave a feedback after you end the session
User 23/05/2018 - 05:26
yes exactly what i got
Excelchat Expert 23/05/2018 - 05:26
:D.. so you can do this for the entire list now
User 23/05/2018 - 05:26
yes
Excelchat Expert 23/05/2018 - 05:26
please leave a feedback after you end the session

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.