Excel - applying formulas to data copied from internet explorer

  • Thread starter Thread starter etymologist
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup Formula 7
dynamic formula needed 26
sorting dates in excel 4
Chart of frequences of values 3
Copying data different sheet 2
formula to copy ocurrences... 4
Pls Help Me! Creating Chart 1
Percentage Formulas 2

Back
Top