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 |