Thread: formula help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TMF in MN
 
Posts: n/a
Default formula help

A B C
1 US JEFF SMI
2 UW LISA SMI
3 WJ MIKE BIS
4 WF LISA BIS

I would like a formula in column C that returns the SMI value when column A
begins with a U but the second digit is variable.

THANK YOU!
TF