ExcelBanter - Location of space in a text in a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Location of space in a text in a cell (https://www.excelbanter.com/excel-worksheet-functions/112354-location-space-text-cell.html)

Rasoul Khoshravan

Location of space in a text in a cell

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

JLatham

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?

All times are GMT +1. The time now is 03:21 PM.