| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS
Hello,
I wish to combine two cells by using cell A1 and trimming or abbreviating cell B1. What function and/or macro can I use to recognize whether the cell B1 contains one or mutliple words, in which case it would trim to 3 first letters or abbreviate to first letter of each word only, respectively. So far I have managed to do: =A1 &concatenate(arrayFormula(if(not(isError(regexextr act(split(B1," "),"\w+"))),left(split(B1," "),3)," " & split(B1," ")))) But thid will take the first three letters of each word... Please help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to copy the first word or two words from a cell containing a complete sentence to another cell | Excel Discussion (Misc queries) | |||
| How do I abbreviate words? | Excel Discussion (Misc queries) | |||
| Delete words in cell if that word is in red | Excel Programming | |||
| Separate last word in cell with more than 2 words? | Excel Worksheet Functions | |||
| Comparing Two Columns - Multiple Words in Same Same Word | Excel Programming | |||
Threaded Mode
