Updating output with first letter as "I"

[Dinesh_Excel]

Hello Friends,

I need help in getting an output in location column as "Internal" if column A starts with letter "I" any other text or number should be " External"

Appreciate your help here.

 

[vletm]

Dinesh_Excel
Is there always seven rows data?
if only few ... then for B2

=IF(LEFT(A2,1)="I","Internal","External")

but if much much more
... then You would use something else

 

[rahulshewale1]

Hii @Dinesh_Excel ,


cell B2 :

=IF(ISNUMBER(FIND("I",A2)),"Internal","External")


Regard
Rahul shewale

 

[Dinesh_Excel]

thank you all its working ..Appreciate your help