**Question description:**

*This user has given permission to use the problem statement for this blog.*

How can I take a group of emails on outlook and copy it into a column on excel?

Solved by S. F. in 40 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
03/05/2018 - 04:26

Hi

Excelchat Expert
03/05/2018 - 04:26

Welcome to Got it Pro

Excelchat Expert
03/05/2018 - 04:26

Can you paste some email ids here so that i can help you out

User
03/05/2018 - 04:27

sure. give me a second please.

Excelchat Expert
03/05/2018 - 04:28

Ok

User
03/05/2018 - 04:30

Abhishek Ratnakar <abhishek.ratnakar@oracle.com>; Alex Zhao <alex.zhao@oracle.com>; Amelia Sherry <amelia.a.sherry@oracle.com>; Arthur Sambar <arthur.sambar@oracle.com>; Bill Habermaas <bill.habermaas@oracle.com>; Bill Shortell <bill.shortell@oracle.com>; Bonnie Sedotto <bonnie.sedotto@oracle.com>; Brian Concannon <brian.concannon@oracle.com>; Brian Thompson <brian.thompson@oracle.com>; Cathy Tenga <cathy.tenga@oracle.com>; Chandra Busireddy <chandra.busireddy@oracle.com>; Christopher Kerekes <christopher.kerekes@oracle.com>; Claire Panthier <claire.panthier@oracle.com>; Clifford Sanchez <clifford.sanchez@oracle.com>; Dan Stern <daniel.stern@oracle.com>; Daniel Nissen <daniel.nissen@oracle.com>; Marc Manza <marc.manza@oracle.com>; Maria Martinez <maria.martinez@oracle.com>; Matthew Angelos <matthew.angelos@oracle.com>; Melanie Mcandrews <melanie.x.wright@oracle.com>; Michael Edry <michael.edry@oracle.com>; Michele Favaro <michele.favaro@oracle.com>; Michele Williams <michele.williams@oracle.com>; Milan Sutaria <milan.sutaria@oracle.com>

User
03/05/2018 - 04:30

Please don't send anything out to them!

Excelchat Expert
03/05/2018 - 04:31

Please see

[Uploaded an Excel file]

Excelchat Expert
03/05/2018 - 04:31

This is how we will get them

Excelchat Expert
03/05/2018 - 04:31

See sheet 2

Excelchat Expert
03/05/2018 - 04:32

Did you see?

User
03/05/2018 - 04:32

I only can see Sheet 1

User
03/05/2018 - 04:32

No

Excelchat Expert
03/05/2018 - 04:32

Sheet 2 is in next tab

Excelchat Expert
03/05/2018 - 04:32

See

[Uploaded an Excel file]

Excelchat Expert
03/05/2018 - 04:33

Pasted in sheet 1 only

[Uploaded an Excel file]

User
03/05/2018 - 04:33

I see the result but how did you do that?

Excelchat Expert
03/05/2018 - 04:33

I will tell you the steps

User
03/05/2018 - 04:33

okay, great!

Excelchat Expert
03/05/2018 - 04:33

Please keep doing the same on your excel on your pc

Excelchat Expert
03/05/2018 - 04:33

copy this email and paste in any cell

Excelchat Expert
03/05/2018 - 04:33

then click on data tab above

Excelchat Expert
03/05/2018 - 04:34

select text to columns

Excelchat Expert
03/05/2018 - 04:34

Are you doing?

User
03/05/2018 - 04:34

yes

Excelchat Expert
03/05/2018 - 04:34

Then select de limit

Excelchat Expert
03/05/2018 - 04:34

click next

Excelchat Expert
03/05/2018 - 04:34

choose semicolon

Excelchat Expert
03/05/2018 - 04:34

then next

Excelchat Expert
03/05/2018 - 04:35

finish

Excelchat Expert
03/05/2018 - 04:35

did you do?

Excelchat Expert
03/05/2018 - 04:35

Please tell

User
03/05/2018 - 04:35

I tried it but it didn't work. Can I use the emails I sent to you and just copy them?

Excelchat Expert
03/05/2018 - 04:35

Sure you can copy them

Excelchat Expert
03/05/2018 - 04:36

but i am telling you how you can do it

Excelchat Expert
03/05/2018 - 04:36

you have to delimit them then they will come in diofferent column

Excelchat Expert
03/05/2018 - 04:36

then you will select them and copy them and then paste as special

Excelchat Expert
03/05/2018 - 04:36

select transpose and you will get the result

Excelchat Expert
03/05/2018 - 04:36

Do you get it?

User
03/05/2018 - 04:37

hang on a sec

Excelchat Expert
03/05/2018 - 04:37

ok

Excelchat Expert
03/05/2018 - 04:39

Are you able to do it?

User
03/05/2018 - 04:39

No.

Excelchat Expert
03/05/2018 - 04:39

Let me know if you are stuck anywhere?

Excelchat Expert
03/05/2018 - 04:39

Did you use delimit to get the ids in different columns?

User
03/05/2018 - 04:39

After I copy from Outlook where do I paste it? In A1

Excelchat Expert
03/05/2018 - 04:40

Yes

Excelchat Expert
03/05/2018 - 04:40

paste in A1

Excelchat Expert
03/05/2018 - 04:40

and then click on data tab

Excelchat Expert
03/05/2018 - 04:40

choose text to columns

Excelchat Expert
03/05/2018 - 04:40

and then delimited

User
03/05/2018 - 04:40

u said paste special as what? text?

Excelchat Expert
03/05/2018 - 04:40

that is afterwards

Excelchat Expert
03/05/2018 - 04:40

first click on data tab and choose text to columns

User
03/05/2018 - 04:40

It doesn't let me go to text to columns

Excelchat Expert
03/05/2018 - 04:41

may be because you may have double clicked

Excelchat Expert
03/05/2018 - 04:41

just paste the data in A1 and then dont click

Excelchat Expert
03/05/2018 - 04:41

directly click on data tab

User
03/05/2018 - 04:41

but don't I need the whole list?

Excelchat Expert
03/05/2018 - 04:41

yes

Excelchat Expert
03/05/2018 - 04:41

select all the email ids

Excelchat Expert
03/05/2018 - 04:41

paste in a1

Excelchat Expert
03/05/2018 - 04:42

then click on data tab

Excelchat Expert
03/05/2018 - 04:42

Did you get?

Excelchat Expert
03/05/2018 - 04:42

are you able to do text to columns?

User
03/05/2018 - 04:43

No. I did text to columns and delimited, semi colon and it didn't copy it

Excelchat Expert
03/05/2018 - 04:43

First select the outlook email ids

Excelchat Expert
03/05/2018 - 04:43

nd paste in excel

Excelchat Expert
03/05/2018 - 04:43

then click on data tab and choose delimited

Excelchat Expert
03/05/2018 - 04:44

and then use semicolon

Excelchat Expert
03/05/2018 - 04:44

and then finish it

Excelchat Expert
03/05/2018 - 04:44

Do you get it?

Excelchat Expert
03/05/2018 - 04:45

You need to follow as i said

User
03/05/2018 - 04:46

Okay lets start over.

User
03/05/2018 - 04:46

or maybe you can demonstrate

Excelchat Expert
03/05/2018 - 04:46

First copy the email list from outlook

Excelchat Expert
03/05/2018 - 04:47

i cannot demonstrate as this spreadsheet does not support text to columns

Excelchat Expert
03/05/2018 - 04:47

Copy the email in excel in A1

Excelchat Expert
03/05/2018 - 04:47

en click on data tab

Excelchat Expert
03/05/2018 - 04:47

selecte delimited

Excelchat Expert
03/05/2018 - 04:47

then next

Excelchat Expert
03/05/2018 - 04:47

then select semicolon

Excelchat Expert
03/05/2018 - 04:47

then finish

Excelchat Expert
03/05/2018 - 04:47

Now all the email ids are in columns

Excelchat Expert
03/05/2018 - 04:48

you need to get them in rows in one column

Excelchat Expert
03/05/2018 - 04:48

so copy them and then paste special and select trensposr

Excelchat Expert
03/05/2018 - 04:48

That is how it can be done

User
03/05/2018 - 04:54

Okay I got them separated but now need to put in a colum what is trensposr?

Excelchat Expert
03/05/2018 - 04:54

So copy the data and paste in some cell

Excelchat Expert
03/05/2018 - 04:54

when you paste data there is a dropdown that appears

User
03/05/2018 - 04:54

Never mind. I got it! thanks so much :)

Excelchat Expert
03/05/2018 - 04:54

Cool

Excelchat Expert
03/05/2018 - 04:54

Hope this session has helped you

Excelchat Expert
03/05/2018 - 04:54

:)

Excelchat Expert
03/05/2018 - 04:54

Please do give good rating

Excelchat Expert
03/05/2018 - 04:54

It would really help a lot

Excelchat Expert
03/05/2018 - 04:57

Are you there?

Excelchat Expert
03/05/2018 - 04:57

You can provide your rating when you end the session

Excelchat Expert
03/05/2018 - 05:02

Are you there?

**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.*