How do i get the last position of a char (space) in a string?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to knok how do i get the last ocurrency of a char in s astring.
Example:
"i like dogs and cats" and i need to return the last position of the space,
i want to return 16 in this string, but i want to do it with some function
 
I need to knok how do i get the last ocurrency of a char in s astring.
Example:
"i like dogs and cats" and i need to return the last position of the space,
i want to return 16 in this string, but i want to do it with some function
Click to expand...


=FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),
LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))


--ron
 

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

Find position number of third space 6
Difficulty cleaning some char(63) characters 1
Help finding the last space in a cell 2
How to find multiple same char in a string in Excel? 3
How to reference Cells AA and forward with CHAR (and a bonus quest 2
Sorting by number of ocurrences! 4
The Last of Us - Part I (PC) 6
std::string to char* 6

Back
Top