View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default 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?