Expert Solution - Excel COLUMN Problems

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

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

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

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

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