Excel - applying formulas to data copied from internet explorer

[etymologist]

I pasted some data from internet explorer and when i tried to applyin
formulas to them it showed error #VALUE!
I could no create charts too

i m attaching the file.
can anyone help me ou

Attachment filename: moserbaer.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=64852

 

[Biff]

Hi Rohit!

That data you pasted is text. It has unseen characters
embeded in the numbers you see. The character is one I've
never seen before. It looks like this: '''

You're data may look like this: 198.18

But Excel see's this: 198.1'''

I'm not sure how to get rid of that. Everything I tried
failed.

CLEAN() failed, TRIM() failed. The only way I could get it
to convert was use a formula like this:

=LEFT(G6,LEN(G6)-1) and then copy an MT cell and paste
special add.

So, to sum it up, I don't have a real solution. sorry

Biff

 

[Biff]

Hi Rohit!

You can still do calculations on "text numbers" since all
your formulas are doing is simple subtraction:

=--(LEFT(G6,LEN(G6)-1)-LEFT(G5,LEN(G5)-1))

Biff

 

[Biff]

After some more tinkering, I found that Dave McRitchie's
TrimAll macro will fix the problem.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Biff