HomeApplicationOffice information

Excel can't remove marks? Why and how to fix it?

What is the reason why Excel cannot remove marks and how to fix it? Let's find an effective solution with TipsMake!

What is the reason why Excel cannot remove marks and how to fix it? Let's find an effective solution with TipsMake!

If you are someone who regularly works with Excel, you will definitely not avoid the error of not being able to uncheck marks. This is a fairly common error but luckily it's quite easy to fix. The following is a guide to quickly and effectively fix the Excel error of not being able to remove marks .

Excel can't remove marks? Why and how to fix it? Picture 1

Share how to quickly fix the problem of Excel not being able to remove marks

To fix the error of not being able to remove marks in Excel, there are many different ways. Apply one by one to see which method suits you best.

Functions to remove marks in Excel - Quick action

If you want to remove marks in Excel, using a function is a quick and easy method applied by many technology enthusiasts. The detailed implementation is:

  1. Step 1 : Open the data file you want to unmark, select File .
  2. Step 2 : Select Options .
  3. B3 : Select Customize Ribbon > Double left click on Developer to activate the VBA tool > Then press OK .

Excel can't remove marks? Why and how to fix it? Picture 3

  1. Step 4 : Click Developer > Select Visual Basic .
  2. B5 : Right click on the Sheet you want to uncheck > Select Insert > Select Module .
  3. Step 6 : Copy all data (as shown) and paste it into the Module .

Excel can't remove marks? Why and how to fix it? Picture 5

  1. Step 7 : Return to the Excel page, select the position you want and enter the function =bo_dau_tieng_viet(cell_position) > Enter

Excel can't remove marks? Why and how to fix it? Picture 6

After completing the above steps, you can remove the mark as you wish. Besides, there are also many faster and more effective methods, please refer to it further.

2. How to remove Vietnamese accents through application software

Use Unikey software

  1. Step 1 : Open the Excel file, select the data area you want to uncheck > Press Ctrl + C to copy the data > Right-click and select the Unikey icon > Select Tools.[CS+F6] .
  2. Step 2 : Highlight the positions of the cells you want to remove marks from.,
  3. B3 : Check the box Remove marks > Click Convert code .
  4. Step 4 : Press the key combination Ctrl + V to paste the removed text into the location you want.

Excel can't remove marks? Why and how to fix it? Picture 8

Using Evkey software:

  1. Step 1 : Open the Excel file then copy the content you want to uncheck.
  2. Step 2 : Click to select EVkey > Transcode. > select Remove marks > Transcode > OK > Close .
  3. Step 3 : Finally, paste the content you copied and complete. 

Excel can't remove marks? Why and how to fix it? Picture 10 As for removing Excel marks on Macbook devices, it will be a little more difficult but it's okay, let me guide you. You can use Unikey software as above, and you can also use VBA

Below are specific instructions:

  1. Step 1 : Press the key combination Alt + F11 to open the VBA window .
  2. Step 2 : Select Insert > Module .
  3. Step 3 : Copy and paste the following code into Module .
Function ConvertToUnSign(ByVal sContent As String) As String Dim i As Long Dim intCode As Long Dim sChar As String Dim sConvert As String ConvertToUnSign = AscW(sContent) For i = 1 To Len(sContent) sChar = Mid(sContent, i, 1 ) If sChar '' Then intCode = AscW(sChar) End If Select Case intCode Case 273 sConvert = sConvert & 'd' Case 272 sConvert = sConvert & 'D' Case 224, 225, 226, 227, 259, 7841, 7843, 7845, 7847, 7849, 7851, 7853, 7855, 7857, 7859, 7861, 7863 sConvert = sConvert & 'a' Case 192, 193, 194, 195, 258, 7840, 7842, 7844, 7846, 7848, 7850, 7852 , 7854, 7856, 7858, 7860, 7862 sConvert = sConvert & 'A' Case 232, 233, 234, 7865, 7867, 7869, 7871, 7873, 7875, 7877, 7879 sConvert = sConvert & 'e' Case 200, 201 , 202, 7864, 7866, 7868, 7870, 7872, 7874, 7876, 7878 sConvert = sConvert & 'E' Case 236, 237, 297, 7881, 7883 sConvert = sConvert & 'i' Case 204, 205, 296 , 7880 , 7882 sConvert = sConvert & 'I' Case 242, 243, 244, 245, 417, 7885, 7887, 7889, 7891, 7893, 7895, 7897, 7899, 7901, 7903, 7905, 7907 sConvert = sConvert & 'o' Case 210, 211, 212, 213, 416, 7884, 7886, 7888, 7890, 7892, 7894, 7896, 7898, 7900, 7902, 7904, 7906 sConvert = sConvert & 'O' Case 249, 250, 361, 432, 7909, 7911, 7913, 7915, 7917, 7919, 7921 sConvert = sConvert & 'u' Case 217, 218, 360, 431, 7908, 7910, 7912, 7914, 7916, 7918, 7920 sConvert = sConvert & 'U' Case 253, 7923, 7925, 7927, 7929 sConvert = sConvert & 'y' Case 221, 7922, 7924, 7926, 7928 sConvert = sConvert & 'Y' Case Else sConvert = sConvert & sChar End Select Next ConvertToUnSign = sConvert End Function
  1. Step 4 : Go back to the Excel file and select File -> Options .
  2. Step 5 : Continue selecting Trust Center -> Trust Center Settings .
  3. Step 6 : In the Macro Settings section, select Enable all macros (not recommended; potentially dangerous code caption) in the Macro Settings section. In the Developer Macro Settings section, select Trust access to the VBA project object model .

Excel can't remove marks? Why and how to fix it? Picture 12

  1. Step 7 : At this point, you have finished building the ConvertToUnSign() function. Return to the spreadsheet, for example, if you want to convert cell D6 data to unsigned, enter the following formula: =ConvertToUnSign(D6) .
  2. B8 : Press Enter -> the data has been converted to unsigned: However, building the function takes a lot of time and is not very effective when you want to convert a large amount of data.

These are the easiest basic methods to remove accents in Excel for you. Nice to know you, wish you success.

5 ★ | 1 Vote

You should read it

May be interested

Office information