Switch Signs
Hi everyone. I have a large block of data. In column A is an account
number. In columns B thru Z is numerical data. Is there a way to
programatically scan column A, and if the last 4 characters in the contents
of column A are 888Z, then change the sign of the numbers in columns B thru
Z of the same row? Thanks in advance!
|