Forum

Notifications
Clear all

Removing asterisks from the cells

2 Posts
2 Users
0 Reactions
93 Views
(@usb)
Posts: 244
Honorable Member
Topic starter
 

In the attached file -
How do I lower the asterisks that are at the beginning of the number
Each row has a different number of asterisks.
Thanks!!

 
Posted : 26/06/2021 12:27 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Lea,

If you mean that you want to remove the asterisks, then you can use Find & Replace on the column and replace them with nothing. Be sure to prefix the asterisk with the tilde so that only the asterisks are removed i.e. in the 'Find What' field enter ~*

Mynda

 
Posted : 26/06/2021 12:45 am
Share: