| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I get Excel (2003) to return just the first 4 words (of an
try this with your string in A1
=LEFT(A1,FIND(" ",A1,FIND(" ",A1,FIND(" ",A1,FIND(" ",A1,FIND(" ",A1,1)+1)+1)+1))) Mike "ship" wrote: Hi How can I get Excel (2003) to return just the first 4 words of another cell? With thanks Ship Shiperton Henethe |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return the words in every 5th row | Excel Discussion (Misc queries) | |||
| Excel 2003 figures to words | Excel Discussion (Misc queries) | |||
| return mulitple values Help!!! Excel 2003 | Excel Discussion (Misc queries) | |||
| HOW DO I DISPLAY NUMBERS AS WORDS IN EXCEL 2003? | Excel Discussion (Misc queries) | |||
| need IF function to return 0 if it finds a one out of three words | Excel Worksheet Functions | |||
Threaded Mode
