ExcelBanter - eliminate partial text in many fields

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - eliminate partial text in many fields (https://www.excelbanter.com/excel-worksheet-functions/123774-eliminate-partial-text-many-fields.html)

BuffaloBilly

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?

Teethless mama

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?

All times are GMT +1. The time now is 01:13 AM.