Macro for removing bullet points in Microsoft Excel cells

1145515 pts.
Tags:
Microsoft Excel
In Microsoft Excel, I have a column that has thousands of cells in it. The cells include:
  • Text
  • Bullet point
I need a macro which would delete all those bullet points (but not the text). I don't want to do this manually - would take up too much time. Can I do it?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

A quick and easy way to to this is to use the find/replace feature. 

Use ctrl+f and go to the replace tab. Click on a cell with a bullet point and copy the contents that you want removed. Paste that into the “Find what:” query and leave the “Replace with:” query blank. Click “Replace All” to remove all of the bullet points.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    If you want to remove numberings or bullets, you can apply a formula to solve it. Select a blank cell that you will place the result, and type this formula = RIGHT(D10, LEN(D10)-2), and press Enter key, then drag fill handle over the cells you want to remove the bullets or numberings.
    133,595 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: