Eliminating Excess Data

[Jakila2]

Hi,

I am attempting to create a chart with a lot of data. I have copied and pasted my data from a source online. There's just one issue: there is some excess data in certain cells and I want to find a way to eliminate it, without manually going into each cell and deleting.

It's actually fairly standard in the way it is laid out. Here's what my data looks like:

Last Trade
1,430.70 5:01PM EST
1,431.10 5:01PM EST
1,431.90 5:01PM EST
1,432.60 5:01PM EST

What I want to eliminate is the "5:01 PM EST" in all of the cells, so that you only see the "last trade" price, which is the "1,430.70" and so on.

Is there a way to cut out the "5:01 PM EST" for all of my data en masse?

[Blake 7]

if your data is in col a put this in any col you want 1,430.70, 1,431.10, 1,431.90, 1,432.60

to appear, you can then copy and paste special back in to col a

=LEFT(A1,LEN(A1)-10)

or you can simply highlight the col and find "5:01 PM EST" and replace with ""

is this what you are after?

[Jakila2]

The find and replace bit worked like a charm. Surprised I wasn't aware of that before.

Thanks, Blake 7.