Location of space in a text in a cell
"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
"Rasoul Khoshravan" wrote:
Is there any command to give the location (address, how many characters from
left) of a space in a text in a cell?
|