Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
similar to...
=LEFT(A1,SEARCH(" ",A1)-1) but where the 1st 2 (or possibly 3) words are required to be returned what do i need to change or what script do i need here A B 100 AKER BALTO 100 AKER 100 AKER BASTION 100 AKER 100 AKER BODECIA 100 AKER DE WET SISQO DE WET DE WET SKYE DE WET DE WET STOFFEL DE WET EL SHADAI LULU EL SHADAI EL SHADAI MARMITE EL SHADAI EL SHADAI MIMI EL SHADAI |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
find a string of nth occurance & pick next 3 words | Excel Worksheet Functions | |||
split string based on a SET of words | Excel Discussion (Misc queries) | |||
i need help creating a function that will extract words from a string of text | Excel Worksheet Functions | |||
Extracting the last set of words from a text string | Excel Worksheet Functions | |||
How do I do a multiple search using key words in a text string | Excel Discussion (Misc queries) |