Find and Replace not replacing a part of field

[BENJAMIN2]

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.

[binuacs]

@BENJAMIN2 please see the data type error. you need to change the data type to string

[BENJAMIN2]

I tried changing to all data types still same issue.

[DataNath · Accepted solution]

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.