Find & replace with text
 

I have a column in excel that has invoice numbers from two departments
They start with S-####### or WO-######. I want to add another column and
insert text "counter" if it is an invoice that starts with S and text "work
order" if invoice number started with WO*. I tried the IF function but my
result always comes out false. Can someone help please?

Find & replace with text
 

=if(right(a2,1)="s","Counter","Work Order")
if the only two options are S* and WO*

=if(left(a2,1)="s","Counter",if(left(a2,2)="wo","W ork Order","Not specified"))



Waheeda Ali wrote:

I have a column in excel that has invoice numbers from two departments
They start with S-####### or WO-######. I want to add another column and
insert text "counter" if it is an invoice that starts with S and text "work
order" if invoice number started with WO*. I tried the IF function but my
result always comes out false. Can someone help please?

--

Dave Peterson

Find & replace with text
 

Thank you Dave. It worked.

"Dave Peterson" wrote:

=if(right(a2,1)="s","Counter","Work Order")
if the only two options are S* and WO*

=if(left(a2,1)="s","Counter",if(left(a2,2)="wo","W ork Order","Not specified"))



Waheeda Ali wrote:

I have a column in excel that has invoice numbers from two departments
They start with S-####### or WO-######. I want to add another column and
insert text "counter" if it is an invoice that starts with S and text "work
order" if invoice number started with WO*. I tried the IF function but my
result always comes out false. Can someone help please?

--

Dave Peterson