View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fr. Vandecan Fr. Vandecan is offline
external usenet poster
 
Posts: 2
Default Search lastname + firstname (search on uppercase)

Hello,
I have 2 columns a and b containing firstname (a), lastname (b). The data is
input like allways (you never know how) sometimes upper case and lower case
are mixed etc ...
So I would like to be able to search on upper case for both columns. How do
i combine search on both columns and upper case ?

Thanks for help