Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
93
Views
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
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