SEGREGATE THE SIR NAME

[Guest]

SIR,
I m working in one sheet where lot of name are available with sir names.Now
i want to segregate the sir name from the name column and want to insert in
another new column. I mean seperate the sir name with the full name.


Thanks and Best Regards
ZEESHAN ANIS

 

[Guest]

Hi,

If I've understood correctly, select your column of names and then

Data|Text to columns

and follow the wizard.

Mike

 

[IanKR]

I m working in one sheet where lot of name are available with sir

names.Now i want to segregate the sir name from the name column and
want to insert in another new column. I mean seperate the sir name
with the full name.


Thanks and Best Regards
ZEESHAN ANIS

If your names are in col A (as <Forename Surname> with a space between the
two parts) put this formula in col B and copy down:

=MID(A1,FIND(" ",A1)+1,LEN(A1)-FIND(" ",A1))

 

[Guest]

Sir Mike ,
Infact I have lot of names in the column with the sir names like
ZEESHAN ANIS
NOMAN ANIS
RIZWAN SHAMIM
IMRAN M. KHAN
ASAD MUHAMMAD

now I want to seperate the sir name in another column. like

Anis
Anis
Shamim
Khan
Muhammad

Its above 1000 names so kindly provide me the shortcut to segregate the same.


Regards
ZEESHAN ANIS

 

[Guest]

Dear Sir,
Thanks for reply. as I wrote in my last query please I am
giving you example to emplain easily.

ZEESHAN ANIS
NOMAN ANIS
SYED KAMRAN KHAN
SYED USMAN SHAMIM AHMED

Lot of names in one column and I want to sagregate the sir name from the
full names .
THANKING YOU.