Copying text from website to excel strange format

What is the URL for the website. We may be able to offer suggestions if we know the website.

Many of the characters you are getting from the web site are not ASCII characters, they are some extended character set. For example, "Wheat Flour" is not ASCII text with a bold format, it is completely different characters that are part of a bold character set. The odd character codes disrupt Excel's coding to format the text into a wrapped cell. This is pretty much a specific web site issue.

Is it a public site, or do you need a login? Please provide the URL for the text you copied here.

Here are the individual characters with their Unicode codes, and things get bad when we hit Wheat Flour:

character set.jpg

Access Denied Error 16 groceries.aldi.co.uk 2024-10-09 15:26:07 UTC

What happened? This request was blocked by our security service Your IP: 108.28.244.78 Proxy IP: 45.60.151.100 (ID 101842-100) Incident ID: 1842000250061637545-139677275799029374

I was able to reach it through my VPN using a UK server. I don't know why I was blocked. Stand by.

The text is directly entered in the web site code like that. The only way I know of to load it into Excel as ASCII text is to translate it character-by-character. I suppose this could be done with VBA, but there is no simple way to just paste in the text and have it work. As far as Excel knows, the text that appears as Wheat Flour (just as one example) could be Chinese, Arabic, or gibberish. It does not know that those codes have any relationship to the letters "Wheat Flour". I am not familiar with the character set they are using, so even to write VBA to do this would require (for me) a lot of research so I'm not really equipped to do this myself.

Just for shiitakes and giggles, here is how the Forum software interprets those character codes:

Vegetables (55%) (Cabbage, Mung Beansprouts, Carrot, Green Pepper, Shiitake Mushroom, Onion), Filo Pastry (34%) (퐖퐡퐞퐚퐭 퐅퐥퐨퐮퐫, Fully Refined 퐒퐨퐲퐚 Oil, Salt), Fully Refined 퐒퐨퐲퐚 Oil, 퐒퐨퐲 Sauce (Water, 퐒퐨퐲퐚 Bean, 퐖퐡퐞퐚퐭 퐅퐥퐨퐮퐫, Salt), Sugar, Corn Starch, Garlic, Salt, 퐒퐞퐬퐚퐦퐞 퐎퐢퐥, White Pepper, Potato Starch.

Also blocked. Don't have UK server as does Jeff, so I am leaving this up to others.

For what it's worth, I didn't have any problem accessing the website/URL.

I copied the text of the recipe into MS Word and into Excel. I also copied the text from Word into Excel. The Word version looks best.