Location of space in a text in a cell

  • Thread starter Rasoul Khoshravan
  • Start date
R

Rasoul Khoshravan

Is there any command to give the location (address, how many characters from
left) of a space in a text in a cell?
 
J

JLatham

"Rasaoul Khoshravan was here" in cell A1, in any other cell
=FIND(" ",A1)
will return 8

You could even find the 2nd space in the phrase with this:
=FIND(" ",A1,FIND(" ",A1)+1)
returns 19
 
Top