Location of space in a text in a cell

  • Thread starter Thread starter Rasoul Khoshravan
  • Start date 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?
 
"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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula/Function for Counting Characters in a cell 4
Excel Subtract text after the third space and before the fourth (from between spaces) 3
Need function to return numbers at beginning of text 2
Remove e-mail address from general text field. 2
Set the Length of the Cell 1
Excel Help creating Excel formula 1
Truncating a cell entry to the last full word 4
Help finding the last space in a cell 2

Back
Top