View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
fran fran is offline
external usenet poster
 
Posts: 4
Default Finding a string

Hello

I have a list of peoples names which are prefixed by a
title. The prefixes cannot be separated into another
column.

Is there any way I can Find the whole of the persons name,
without including the prefix.

eg if myname = Susan Brown
can I find it if the cell contains Mrs Susan Brown


Any help much appreciated