| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
return second or third word in a cell
If you have several words entered into a cell is there a formula that I can
use in another cell that will return the third word in the orignial cell. The words are always capitalized and separated with a space. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make cell equal a word if a data validation cell has a word in it | Excel Discussion (Misc queries) | |||
| return 1st word in string | Excel Discussion (Misc queries) | |||
| Find a cell with a word and then return the next cell down | Excel Discussion (Misc queries) | |||
| Return Date using two dates and a word | Excel Discussion (Misc queries) | |||
| need formula to search column for a word and return another word | Excel Discussion (Misc queries) | |||
Threaded Mode
