Thread: [Solved] Help needed with IF formula with a Vlookup
View Single Post
 
Old 08-31-2017, 11:58 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
=If(Mid(D19,3,1)="P",Left(D19,2) & "R" & Right(D19,3),D19)

If the third character is always either P or R, then the If and Mid are superfluous and you could just use...

=Left(D19,2) & "R" & Right(D19,3)
Reply With Quote