truncating a value

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

Guest

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
 
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.
 
What I find works well when you have consistent spacing like this is DATA |
TEXT TO COLUMNS, then delete the new column.

Dennis
=========
 
Back
Top