Thread: SEARCH function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
F. Lawrence Kulchar F. Lawrence Kulchar is offline
external usenet poster
 
Posts: 124
Default SEARCH function

I am using the SEARCH function to search for a space ("") within a cell such
as follows:

A

1 I LOVE YOU

=SEARCH("",A1)

UNFORTUNATELY, IT IS FINDING THE SPACE IN THE FIRST (1ST) POSITION.

THIS IS TRUE NO MATTER WHAT THE CELL STATES...IN OTHER WORDS, FOR ALL CELLS,
A SPACE IS ALWAYS FOUND IN THE FIRST POSITION.

How is this "dilemma" corrected?

Thanks,

FLKulchar