Help needed to edit CSV files

[savan28]

Hello everyone,
I have started a new eCommerce website and need some help to edit the csv.

Basically I get a new updated CSV file every 2 days with edits in more than 5000 products. I need a quick way to edit the CSV and update the products in the website.

To do this firstly, I need to remove the product code from the name of the cell. The product name is in the following format
8694 3 Piece Set Of Wall Paintings Without Glass,

I need to remove the first set of numbers and to be written as 3 Piece Set Of Wall Paintings Without Glass.
And secondly to optimise the site and for SEO reasons, i need to remove certain characters from the description like, the, is, and and so on,

For example, from the following sentence I need to remove the, are, very and in

The towers are very tall in the city. and the output is tower, tall, city.

Thanks for your help in advance,

[mancubus]

welcome to the forum.

can you post your workbook?
(#2 in my signature)

[savan28]

I have uploaded a example of how the data is

[mancubus]

sample in A2
is it "5008Blue and Sea Green Straight Suit" or "5008 Blue and Sea Green Straight Suit"?
(no space / 1 space between 5008 and Blue)