Thread: Combining LEFT\IF and Concatenation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson
 
Posts: n/a
Default Combining LEFT\IF and Concatenation
Hi glyday,
=IF(LEFT(A2,1)="S","ST" & B2,IF(LEFT(A2,1)="K","LO" &
B2,IF(LEFT(A2,1)="B","BS" & B2,"")))
is one version
Ken Johnson

Reply With QuoteReply With Quote