"Formula is too long" - A simple solution?

[Fruit_and_Veg]

Tweet

Holy Jesus! This little pop up box is driving me round the effing bend!!

I appreciate merchants actually putting a meaningful description in (albeit comma-loaded) but when Excel makes a seemingly simple task mind achingly hard, I want to smash this screen.

I just want to remove all the comma's and clean up a feed. Can I do this by automatically limiting a cell's characters or something?

[Jeff]

I do this by copying it into notepad or wordpad and doing a find/replace for the characters I want to remove.

There's probably a more elegant way of doing it just in Excel, but the way I do it is so quick and easy I've never bothered looking into alternatives.

[Fruit_and_Veg]

Thanks. I have actually tried that but with a huge AW feed and it virtually crashed Word, but I'll use that for smaller ones.

[webboy]

Can be done very easy , as you can run it via your web server in php and strip out anything you wish provide a example of the feed

[Barry]

You could download text crawler, its a great little free app.

TextCrawler Download

Ta

Baz