Hi I have a data set where the last digit is non numeric. Then I have a table to replace the non numeric value with a number. I tried by changing the data type from Byte to String and several others however the find replace is not working.
Résolu ! Accéder à la solution.
I tried changing to all data types still same issue.
Hey @BENJAMIN2 - I just downloaded the sample you provided and the reason it isn't working is because none of your 'Amount' fields actually match the 'Data1' in the lookup, and therefore nothing will be replaced. It does work as expected if there are matches in 'Amount' - I added an extra row with 'R' on the end and you can see it functions as expected:
Before:
After:
Workbook attached.