Thread: [Solved] Trying to change the last digit in a column of 10 digit entries
View Single Post
 
Old 04-01-2020, 03:10 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
Try:
=Right(A1,9)&"5"
Reply With Quote