I need to do the following.
Cell A1 contains the text "This is a phrase I am working on"
Cell B1 I need to put there a number showing the word I choose from the phrase (1=first word, 2=second word etc).
Cell C1 In this cell I need to have as result the selected word isolated without spaces.
For example, if I select 3 (third word), the cell C1 should read "a"
I have tried using "find" and "search" and "len" and "substitute" to find how many spaces or how many words are there, but could not achieve desired final result.
Here are the two functions I used so far
=LEN(A1)-LEN(SUBSTITUTE(A1;" ";""))+1 this counts words
=LEN(A1)-LEN(SUBSTITUTE(A1;" ";"")) this counts spaces
Thanks.
Bookmarks