If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Search for a particular letter in the sentence and print
excel has to search for a paticular letter in a row and print the preeciding
word in the next cell |
#2
|
|||
|
|||
Search for a particular letter in the sentence and print
Hi
This formla search for '!' and return whatever is found after the '!' sign. =IF(FIND("!",A1),MID(A1,FIND("!",A1)+1,99),"") Hopes this helps .... Per "ks1" skrev i meddelelsen ... excel has to search for a paticular letter in a row and print the preeciding word in the next cell |
#3
|
|||
|
|||
Search for a particular letter in the sentence and print
Hi, I'm a little confused, do you have a row of cells with content such as:
A1: testing x this y formula z B1: this p is q the r next s cell t along u C1: and a another b example c for d luck and wish to search A1:C1, returning, for example, "the" when your criteria letter is "r"? If not, perhaps you could clarify your requirements a little further. Steve D. "ks1" wrote in message ... excel has to search for a paticular letter in a row and print the preeciding word in the next cell |
#4
|
|||
|
|||
Search for a particular letter in the sentence and print
Or, is it more like one cell containing a sentence.
A1: perhaps this is could work and you wish to return, for example, "is" when your criteria letter is "u"? This could become very messy. If, for instance, your criteria letter appeared twice in the sentence (not unheard of grin) what would you want your result to be? "Steve Dunn" wrote in message news Hi, I'm a little confused, do you have a row of cells with content such as: A1: testing x this y formula z B1: this p is q the r next s cell t along u C1: and a another b example c for d luck and wish to search A1:C1, returning, for example, "the" when your criteria letter is "r"? If not, perhaps you could clarify your requirements a little further. Steve D. "ks1" wrote in message ... excel has to search for a paticular letter in a row and print the preeciding word in the next cell |
#5
|
|||
|
|||
Search for a particular letter in the sentence and print
Try the below....which search for an exclamation in row1 range(A1:Z1) and
returns the cell value of the next cell... =INDEX(A1:Z1,SUMPRODUCT((ISNUMBER(SEARCH("!",A1:Z1 ))* COLUMN(A1:Z1)))+1) -- Jacob (MVP - Excel) "ks1" wrote: excel has to search for a paticular letter in a row and print the preeciding word in the next cell |
Thread Tools | |
Display Modes | |
|
|