truncating a value

[Donna]

H
I am importing dates from a website that includes time zone. ie.,mm/dd/yyyy 13:30 ES and some may come in as m/dd/yyyy 1330 ES What can I use to drop the ES, I think the cut should be from the right as opposed from the left
All help would be appreciate
Donn

 

[Jason Morin]

How about using SUBSTITUTE?

=SUBSTITUTE(A1," ES","")

HTH
Jason
Atlanta, GA

 

[Frank Kabel]

Hi
try
=TRIM(SUBSTITUTE(A1,"ES",""))

--
Regards
Frank Kabel
Frankfurt, Germany

Hi
I am importing dates from a website that includes time zone.

ie.,mm/dd/yyyy 13:30 ES and some may come in as m/dd/yyyy 1330 ES What
can I use to drop the ES, I think the cut should be from the right as
opposed from the left.

 

[Dennis]

What I find works well when you have consistent spacing like this is DATA |
TEXT TO COLUMNS, then delete the new column.

Dennis
=========