Copy and convert worksheet data [Closed]

Report
Posts
18
Registration date
Wednesday December 13, 2017
Status
Member
Last seen
January 23, 2018
-
I have an exported worksheet of data from an InfoPath Form. The results are Yes, No, NA, Blanks and dates; I want to copy all the data to a new worksheet and convert Yes to 1, No to 0 and NA to 9..... didn't know the best solution

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!