Hello all,

I know this might seem trivial but I was bugging my head with lots of search on the net and could not find the working solution.

Basically I would like a macro (not a formula in a cell) that will go through column A and leave only the first 8 characters by deleting the rest. The column is populated with text of various length and each time can have various number of rows. All I need is the first 8 characters shown in all rows no matter how many rows there are.

Thank you so much.