Text from a web page into excel

Pauls123

Board Regular
Joined
Mar 22, 2011
Messages
178
Hi all, I have copied and pasted various data into Excel (2010). I am applying formulas to part of it, in this case a vlookup formula. But it doesnt seem to want to recognise the word which come from the "net". The error I get is #N/A.

If I just type in a word myself, it works perfectly.

Any thoughts,,?

Regards, Paul
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Pauls123

Board Regular
Joined
Mar 22, 2011
Messages
178
For some reason it is not finding the "text" from the net,..??
but it is finding my ordinary text,...??

Paul
 

CWatts

Well-known Member
Joined
Jan 22, 2010
Messages
701
Tough to say, but copy and pastes from the net bring in a bunch of formatting and possibly special characters. Have you tried using Excel's built in external data source option and using that to pull from the web page?

You might have more success with that rather than copy and paste.
 

Pauls123

Board Regular
Joined
Mar 22, 2011
Messages
178
Hi CWatts and thanks. I just tried that but still the same,,..hmm, back to the drawing board,

Regards, Paul
 

CWatts

Well-known Member
Joined
Jan 22, 2010
Messages
701
The only other thing I could think is if there are erroneous spaces in there. Try copying it and pasting special > values to a blank workbook, then moving your cursor around to see if that's it.

If the site is public and you can post the data you're trying to pull, maybe someone could see whats up with it.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,955
Messages
5,599,040
Members
414,280
Latest member
morralletti

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top