eliminate partial text in many fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use sum/average function on 3 consecutive values 2
If - Then Fields 1
SUMIF with criteria "<>" & "=" 4
merge two rows 5
how to eliminate duplicate numbers 5
Eliminating Values from a worksheet 4
comp.os.linux.networking 3
How to subtract a number from a Mergefield? 0

Back
Top