I'm trying to find a UDF formula that will replace data in one column in Sheet 1 (called "GL_Detail) with values from Sheet 2 (called "Replace_Values).
Column A in "GL_Detail" has the following invoice numbers:
10000
10001-in
10002-CM
10003-3
10004-a
10005-A
JE# 5000
I want users to write in the "Replace_Values" sheet in Column A, the value to be replaced (for instance, the "-in", "-CM", "-3", etc) and in Column B the replacing value (in this case, all blanks).
Column B in "GL_Detail" will then show the following:
10000
10001
10002
10003
10004
10005
JE# 5000
Thanks for your help.
Bookmarks