If number starts with "29" then text should be "sales agent"

[luisvanegas]

Hello,

I have a list of hundreds of numbers on column A. I would like to have a formula on column B that if the number starts with the digits "29", then the worlds in column B would be "sales agents", if it does not starts with "29" then to show "customer care agents". Thanks for your help!!

 

[Dryver14]

Excel Workbook
	A	B	C	D
1	28576	Customer Care Agents
2	29576	Sales Agent
3	28576	Customer Care Agent
4	29576	Sales Agent
5	28576	Customer Care Agent
6	28576	Customer Care Agent
Sheet1

 

[Special-K99]

Improving that

=IF(LEFT(A1,2)="29","Sales","Customer Care")&" Agents"

 

[Fishboy]

Hello,

I have a list of hundreds of numbers on column A. I would like to have a formula on column B that if the number starts with the digits "29", then the worlds in column B would be "sales agents", if it does not starts with "29" then to show "customer care agents". Thanks for your help!!

Hi luisvanegas, welcome to the boards.

The following formula in column B could be drag-filled down the length of your data:

=IF(LEFT(A1,2)="29","Sales Agent","Customer Care Agent")

 

[luisvanegas]

THANK YOU !!!! YOU ARE A LIFE SAVER !!!! very detailed explanation!