**Question description:**

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

how to find only the names in a column in excel 2010

Solved by D. U. in 60 mins

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

Excelchat Expert
08/08/2018 - 02:22

Hi.. Welcome to Got It Pro

User
08/08/2018 - 02:22

event management company

Excelchat Expert
08/08/2018 - 02:22

how can i help you today..?

User
08/08/2018 - 02:24

I want to remove all useless words except Names in specific column

Excelchat Expert
08/08/2018 - 02:24

ok..

User
08/08/2018 - 02:24

like i can show you in excell

User
08/08/2018 - 02:24

in pc

Excelchat Expert
08/08/2018 - 02:24

sure..

Excelchat Expert
08/08/2018 - 02:24

could you upload your file in here..??

User
08/08/2018 - 02:25

Can you see it now

Excelchat Expert
08/08/2018 - 02:25

yes..

Excelchat Expert
08/08/2018 - 02:26

so do you want to eliminate word after last name..??

User
08/08/2018 - 02:26

so from here i want only name like in A2 i need John not,MCIPS

User
08/08/2018 - 02:26

how to remove it

Excelchat Expert
08/08/2018 - 02:26

ok.. got it..

User
08/08/2018 - 02:26

yah

Excelchat Expert
08/08/2018 - 02:26

hold on..

User
08/08/2018 - 02:27

But both names i need

User
08/08/2018 - 02:27

in this column

Excelchat Expert
08/08/2018 - 02:27

ok.. hold on..

Excelchat Expert
08/08/2018 - 02:30

I think I got the formula..

User
08/08/2018 - 02:31

I got it but in some cases there are not only phd there are some other things on that case what should i do .....................

Excelchat Expert
08/08/2018 - 02:31

Could you give me some examples..??

User
08/08/2018 - 02:31

yah

User
08/08/2018 - 02:31

wait a second

Excelchat Expert
08/08/2018 - 02:32

ok..

User
08/08/2018 - 02:32

Like pPCCA

User
08/08/2018 - 02:32

MPCCA

User
08/08/2018 - 02:32

#

User
08/08/2018 - 02:32

?

User
08/08/2018 - 02:32

Trade mark sign

Excelchat Expert
08/08/2018 - 02:33

ok..

User
08/08/2018 - 02:34

And so dot

User
08/08/2018 - 02:34

as well

User
08/08/2018 - 02:34

"

User
08/08/2018 - 02:34

'

Excelchat Expert
08/08/2018 - 02:34

are those after or before ","

User
08/08/2018 - 02:35

Maximum times after but in along sheet it creats problem while it stands in before

Excelchat Expert
08/08/2018 - 02:36

ok..

Excelchat Expert
08/08/2018 - 02:37

this formula only take text before ","..

Excelchat Expert
08/08/2018 - 02:37

so anything after "," are no problem..

User
08/08/2018 - 02:38

Yap

User
08/08/2018 - 02:38

But what before

User
08/08/2018 - 02:38

And mid

Excelchat Expert
08/08/2018 - 02:38

if some text before "," like PhD have to use substitute function to eliminate..

User
08/08/2018 - 02:38

May i have a look

Excelchat Expert
08/08/2018 - 02:39

Could you give me full list of name..so I can figure out the logic for you..

User
08/08/2018 - 02:39

yap

User
08/08/2018 - 02:40

soorry not this one

Excelchat Expert
08/08/2018 - 02:41

no problem..

Excelchat Expert
08/08/2018 - 02:41

give me new list..

User
08/08/2018 - 02:41

This one

User
08/08/2018 - 02:42

u got it

Excelchat Expert
08/08/2018 - 02:42

hold on please..

User
08/08/2018 - 02:42

ok

User
08/08/2018 - 02:43

And please remind G. something like that would be only g

Excelchat Expert
08/08/2018 - 02:43

ok

Excelchat Expert
08/08/2018 - 02:45

how about (Elena) Zervou

Excelchat Expert
08/08/2018 - 02:45

Cooper (LION)

Excelchat Expert
08/08/2018 - 02:46

do you want to eliminate name inside of ( )?

User
08/08/2018 - 02:47

Only Cooper but In Elena i need Zervou and E;ena

User
08/08/2018 - 02:47

Not ()

Excelchat Expert
08/08/2018 - 02:47

how about .. M.S.

User
08/08/2018 - 02:48

NO If it is only M.S. in that cell then only MS

User
08/08/2018 - 02:48

Otherwise i don't need

Excelchat Expert
08/08/2018 - 02:48

ok..

User
08/08/2018 - 02:50

In words i need those names only

Excelchat Expert
08/08/2018 - 02:50

ok..

User
08/08/2018 - 02:55

Are you there

Excelchat Expert
08/08/2018 - 02:55

yes..

User
08/08/2018 - 02:55

ok ok

Excelchat Expert
08/08/2018 - 02:55

sorry.. I am working on the formula..

User
08/08/2018 - 02:55

Take your time

Excelchat Expert
08/08/2018 - 03:10

[Uploaded an Excel file]

Excelchat Expert
08/08/2018 - 03:10

ok. this is interim solutions..

Excelchat Expert
08/08/2018 - 03:10

I need teak the formula to work with few exceptions..

User
08/08/2018 - 03:11

Is it possible to chat with u latter

Excelchat Expert
08/08/2018 - 03:12

only within the session time..

User
08/08/2018 - 03:13

ok Thank you very much for your help

User
08/08/2018 - 03:13

it is amaizing

Excelchat Expert
08/08/2018 - 03:13

hold on..please..

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