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
[Uploaded an Excel file]
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
[Uploaded an Excel file]
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
yes please
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
thanks for your help much appreciated and i like your service
User
23/05/2018 - 05:25
Thank you
Excelchat Expert
23/05/2018 - 05:25
did you get this
[Uploaded an Excel file]
Excelchat Expert
23/05/2018 - 05:25
:) glad to help
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.