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))