Create Custom Function

[CRD90]

Hi,

I use the formula =IF(LEFT(a2,6)="838021",RIGHT(a2,8),IF(LEFT(a2,6)="838086",RIGHT(a2,8),a2)) quite regularly.

I was hoping to create my own custom function for this but i can't figure it out!

My VBA is very basic, some help would be much appreciated.

Thanks
C

 

[Fluff]

Hi & welcome to MrExcel.
How about

Function MyIf(St As String) As String
   If Left(St, 6) = "838021" Or Left(St, 6) = "838086" Then
      MyIf = Right(St, 8)
   Else
      MyIf = St
   End If
End Function