|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 27th, 2006, 01:34 AM
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
December 27th, 2006, 01:45 AM
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
