| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return text
Hi, I need to return text from a cell which contains e.g. Our Lady of
The Convent School, Liverpool. I need to return all text before the ",". I know there is a way to do it using LEFT, LEN functions but can't get it to work. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return text
Try...
=LEFT(A1,FIND(",",A1)-1) Hope this helps! In article .com, " wrote: Hi, I need to return text from a cell which contains e.g. Our Lady of The Convent School, Liverpool. I need to return all text before the ",". I know there is a way to do it using LEFT, LEN functions but can't get it to work. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return text
That worked great - thanks very much for your help.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return a block of text based on a single "short name" entry | Excel Worksheet Functions | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| Match text to another worksheet and return a certain value | Excel Worksheet Functions | |||
Linear Mode
