truncating a value

D

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
 
F

Frank Kabel

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

--
Regards
Frank Kabel
Frankfurt, Germany

Donna said:
Hi
I am importing dates from a website that includes time zone.
Click to expand...
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.
 
D

Dennis

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

Dennis
=========
 
Top