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.