How to remove first 8 characters (including space) in a string

Dear Forum expert,

Kindly help me with VBA code for "How to remove first 8 characters (including space) from a string in the entire column of a work sheet.

Example:

Column A - AN02001 Dr. BCDG Hospital, Texas

Result in Column A as - Dr. BCDG Hospital, Texas

Note: I want to do it for the entire column.

Regards

Dear Expert,

Yes, I need a VBA code. Please do the needful.

Regards

May be

Formula:

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

Dear expert,

Thanks for your code. it shows runtime error:5 - Invalid procedure call or argument.

Actually the data in Column C - AN02001 Dr. BCDG Hospital, Texas and Result in Column C should be as - Dr. BCDG Hospital, Texas.

Regards

Try

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Originally Posted by jindon

Try

Please Login or Register  to view this content.

Dear Jindon,

Wow.... works perfect. Thanks a lot.

Regards

Dear Need for excel and Mohadin,

Thanks for your time and support for my requirement.

Regards

One more option

Please Login or Register  to view this content.