Text from a web page into excel

Pauls123

Board Regular
Joined
Mar 22, 2011
Messages
180
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
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
For some reason it is not finding the "text" from the net,..??
but it is finding my ordinary text,...??

Paul
 
Upvote 0
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.
 
Upvote 0
Hi CWatts and thanks. I just tried that but still the same,,..hmm, back to the drawing board,

Regards, Paul
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,144
Members
448,552
Latest member
WORKINGWITHNOLEADER

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
Back
Top