vba for remove all text after a charter

Hello

i try to find out if there are a vba here thats clear all after a chart (*) in column B

Please Login or Register  to view this content.

Hello

Thank you for a quick replay, i wanted all tekst below the chart to be clear, now only * will be replace

Sorry I don't understand.

The code should delete text after asterisk *,
e.g

ABD*123 will be ABC.

If it is not what you want, you need to upload a sample workbook, showing before/after.

Hello

Everything below row 28 will be clear, and that can change but this time i have a chart in B28

Is this how you wanted?

Please Login or Register  to view this content.

Hello

Yes thank you,:-)