Thread: Search A Cell for Certain Letters Then Output a Number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] adambush4242@hotmail.com is offline
external usenet poster
  
Posts: 168
Default Search A Cell for Certain Letters Then Output a Number
I have a column that has cells containing text. These cells could be in
three different formats. If they start with E, I want to output 50. If they
start with SP, I want to output 250. If they start with SPX, I want to
output 100. Any suggestions would be much appreciated.

Thanks

Adam
Reply With QuoteReply With Quote