Thread: How do I create a formula using part of the data in 1 cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
  
Posts: 2,574
Default How do I create a formula using part of the data in 1 cell?
=IF(LEFT(A1,3)="TAD","Ab","")

Replace "" with other IF statements as appropriate.

"SMC0890" wrote:

I am trying to create a conditional formula that will look at the first three
characters in a cell and determine a value based on that. Here are four
examples of the data I am looking at and the values I need returned for each:

Data Value returned should be
TAD12345 Ab
TED1263 Ed
TAC25462 Ab CI
TAT9456 Ab TRM

I need a conditional formula that will look at the first three letters in
each of these and return the value based on that. Any suggestions?


Reply With QuoteReply With Quote