| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort and exclude certain words
Hi again,
Am Sun, 12 Apr 2020 19:12:27 +0200 schrieb Claus Busch: =MID(A1&", "&A1,FIND(" ",A1&", "&A1)+1,LEN(A1)+1) to change only the titles with THE, A and An at the start, try: =IF(OR(LEFT(A1,FIND(" ",A1)-1)={"The";"A";"An"}),MID(A1&", "&A1,FIND(" ",A1&", "&A1)+1,LEN(A1)+1),A1) Regards Claus B. -- Windows10 Office 2016 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Don't sort top two rows? | Excel Discussion (Misc queries) | |||
| data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
| How to exclude header row from sort button sorts? | Excel Discussion (Misc queries) | |||
Threaded Mode
