Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I get Excel (2003) to return just the first 4 words (of another cell)?
Hi
How can I get Excel (2003) to return just the first 4 words of another cell? With thanks Ship Shiperton Henethe |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I get Excel (2003) to return just the first 4 words (of another cell)?
On Fri, 07 Sep 2007 03:37:37 -0700, ship wrote:
Hi How can I get Excel (2003) to return just the first 4 words of another cell? With thanks Ship Shiperton Henethe What do you want to do if there are less than four words in the cell? This should get you started. Substitute what you want for less than four words for the string in the formula below. =IF((LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ","")))<4, "LESS THAN FOUR WORDS", LEFT(TRIM(A1),FIND(CHAR(1),SUBSTITUTE(TRIM(A1)," ",CHAR(1),4))-1)) --ron |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I get Excel (2003) to return just the first 4 words (of an
Assuming you have no carets (^) in your cell, and assuming the cell with the
string you want to act on is A1, try =LEFT(A1,FIND("^",SUBSTITUTE(A1," ","^",4))-1) "ship" wrote: Hi How can I get Excel (2003) to return just the first 4 words of another cell? With thanks Ship Shiperton Henethe |
#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 |
Reply |
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 |