| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
return left most part of cell
anyone know if there is a formula that can return the first word of a string
example: 1 Abelia grandiflora 'Sherwoodii' return - Abelia example: 2 Abies balsamea return - Abies example: 3 Abutilon return - Abutilon what is needed is one formula that will cover all string possibilities Thnkyou if you can help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return a dollar value for a part number entered in a cell | Excel Worksheet Functions | |||
| I need help with an "If" Statement | Excel Worksheet Functions | |||
| Replace part of link address in a cell with a value(date) from ano | Excel Discussion (Misc queries) | |||
| Syntax for inferred cell references | Excel Worksheet Functions | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
Threaded Mode
