Match function

M

markholt

I'm using the Match function & I'm having trouble because I'm copying info
from a web page & pasting it into my Excel - when I paste it - it's actually
a link to the web page...so my function will not work.

How do I convert the data so it will work - I've looked at reformating but
haven't had any luck. I can't use excel's find feature because the data is
too long. That would have been easiest...

Any ideas?

Regards
 
L

Luke M

When you paste in the data, can you do a Paste special - Values?

If your needing the links, another option might be to use the VALUE function.
 

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

Match function: error due to format? 4
if function match 3
Match function won't recognize values unless I type them 4
Excel Data pastes into 2 cells not 1 1
Getting wrong answer with Match Function 3
Index and Match Function Help 5
Wrong results from MATCH function 3
Convert Number to Text for Index/Match 1

Top