This is the first time that I am trying to do Data Validation via RPA so hoping you guy’s can help me out.
I am trying us ensure that on the excel document all Salutations in the column appear as MR. or MRS. (needs to have a dot at the end). I have done it via the Find & Replace option however when I change MR to MR. it also changes MRS to MR.S.
Is there a way that I can select the whole column and ask it to find any without a dot and then add a dot on the end?
Any suggestions will be appreciated as go live date is approaching!