Hi,

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

Data|Text to columns

and follow the wizard.

Mike



"ZEESHAN ANIS" wrote:

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