FIND or SEARCH Function

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

I have several cells that begin with spaces. Is there any
way I can use the FIND or SEARCH funstions to find the
starting position of the first actual "non-space"
character is that cell.

I saw that FIND cannot find "wildcards" but the Help files
say SEARCH can.

I would then want to write an IF function that says, if
the first charcater is at the 9th position, then do
something, otherwise, do nothing. (An IF I can write).

Can anyone lend any insight? Thanks so much in advance.

Don
 
Look up the TRIM function in the help files.
--

HTH,

RD
========================================
Please keep all correspondence within the Group, so all may benefit!
========================================
 
One way, if I understand you correctly:


=IF(AND(LEFT(A1,8)=REPT(" ",8),MID(A1,9,1)<>" "),<something>, "")
 
Back
Top