Macro to leave only the first 8 characters in a range of cells

[gokica]

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.

[zbor]

Try this:

Please Login or Register  to view this content.

[gokica]

Try this:

Please Login or Register  to view this content.

Thank you so much.

I wonder why the macro stops and the debugger is highlighting the following:

Please Login or Register  to view this content.

Once again thank you so much.

Oh I am sorry, I used column A just to simplify the example. Basically I am filtering the first 8 characters of column P in my spreadsheet if this changes anything. But I already changed the values to:

Please Login or Register  to view this content.

[zbor]

Sorry, I've edited post and didn't refresh first...

Please check now..
Also, use CODE TAGS around your code.


Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[gokica]

Sorry, I've edited post and didn't refresh first...

Please check now..
Also, use CODE TAGS around your code.


Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Thank you so much and apologies for not using code tags when inserting a code in my posts. I will follow this rule from now on.

The macro works wonderful. I have two columns that require this procedure so I will just copy and paste the same code and add the second column in my macro.

Once again thank you so much. This is most helpful.

Edit: the code has been edited with the tags in my post above. Thank you.