?
Solved

Can we delete labeled or unlabeled digit in Excel?

Posted on 2016-10-02
7
Medium Priority
?
40 Views
Last Modified: 2016-10-21
Hi The below is a group of data. Can we delete labeled or unlabeled digit in Excel with a simpler way? Thank you

18      34
21      35
23      36
25      36
25      40
27      43
29      45
0
Comment
Question by:eemoon
  • 3
  • 2
6 Comments
 
LVL 9

Expert Comment

by:Koen
ID: 41825430
what are you trying to achieve ? what do you mean with labeled or unlabeled digit?
0
 
LVL 50

Expert Comment

by:Martin Liss
ID: 41825432
Please explain what you mean by "labeled or unlabeled".
0
 

Author Comment

by:eemoon
ID: 41825438
Sorry it is not clear.
The labeled or unlabeled is highlighted one with Bold or other colors
In this case, they are 35, 25, and 43
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 50

Expert Comment

by:Martin Liss
ID: 41825459
When you delete them what should happen to the cell? Should it be blank or should the other data in the column move up?
0
 

Author Comment

by:eemoon
ID: 41825479
it does not matter because I can put them together by sorting. It could be blank
0
 
LVL 50

Accepted Solution

by:
Martin Liss earned 2000 total points (awarded by participants)
ID: 41825555
Here a macro. It deletes all cells on the sheet that are bolded. It could easily be limited to a specific range.

Sub DeleteBold()

Dim cel As Range

For Each cel In ActiveSheet.UsedRange
    If cel.Font.Bold = True Then
        cel.Delete
    End If
Next
End Sub

Open in new window

0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question