I DONT KNOW THE FORMULA TO CHANGE A SPREADSHEET TO UPDATE OLD NAMES TO A NEW NAMES OR NUMBERS .

[JOHNS33LIVECOM]

I HAVE TO SERCH FOR OLD NAME OR NUMBER AND CHANGE IT TO A NEW NAME OR NUMBER. I I AME GOING THROUGE A CHANGE WITH EXCEL 365 AND WINDOWS FROM10 TO 11. CAN U SHOW

ME THE FORMULA PLEASE

THANK YOU

JOHN STASSI 

[#2]

Use the FIND & REPLACE function to do this.
Highlight the area with the data you want to update, press CTRL + H to pull up the find and replace tool...