View Single Post
 
Old 04-03-2020, 08:49 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

That looked right to me at first, but on second thought doesn't it just provide the last two digits? That is, if A1 has "6677889900", your formula will return not "6677889905" (which is what I suppose the OP wants) but just "05".

Pretty close, though; easy enough to fix it:
Code:
=LEFT(A1,8)&SUBSTITUTE(RIGHT(A1,2),"00","05")
Reply With Quote