BhanupriyaP
New Member
I have the data, names Vs some numbers..large data. I want to replace all the numbers with "X". Currently am doing it manually. Is there any way, I can do it faster please? It's my weekly activity and very time consuming at the moment.
Thanks in advance.
Sample:
Output:
Thanks in advance.
Sample:
Sum of Amt | Months | ExpenseDate | ||||
Apr | May | Jul | Aug | Sep | ||
ApproverID | ClaimCurrency | |||||
XYZ | EUR | 276 | 88.35 | |||
EUR | 755.14 | 22.44 | 172.35 | |||
GBP | 636.88 | 50 | 570.34 | |||
ABC | CAD | 999.3 | 2400.59 | |||
CAD | 844.81 | |||||
UVW | USD | 866.07 |
Sum of Amt | Months | ExpenseDate | ||||
Apr | May | Jul | Aug | Sep | ||
ApproverID | ClaimCurrency | |||||
XYZ | EUR | X | X | |||
EUR | X | X | X | |||
GBP | X | X | X | |||
ABC | CAD | X | X | |||
CAD | X | |||||
UVW | USD | X |