| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
eliminate partial text in many fields
I have many fields with, for example, "08:22 CST" and I'd like to eliminate
the "CST" so that I can use an IF formula with these times. How can I eliminate the letters while keeping the numbers in place? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
eliminate partial text in many fields
=--LEFT(A1,5)
format cell as hh:mm "BuffaloBilly" wrote: I have many fields with, for example, "08:22 CST" and I'd like to eliminate the "CST" so that I can use an IF formula with these times. How can I eliminate the letters while keeping the numbers in place? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find partial text contained in another cell | Excel Discussion (Misc queries) | |||
| Adding numbers based on partial text in adjacent cells | Excel Discussion (Misc queries) | |||
| Adding Two Text Fields together | Excel Discussion (Misc queries) | |||
| i have fields that are formatted for text that randomly convert t. | Excel Discussion (Misc queries) | |||
| Finding Partial Text in a Cell | Excel Worksheet Functions | |||
Hybrid Mode
