If or something else for Partial Text Extraction/Reference

  • Thread starter Thread starter sachinattri
  • Start date Start date
S

sachinattri

Hi there,

I have a group of companies :

ABC Corp.
XYZ Insurance
EFG Ltd.
OPQ Private Ltd.
LMN Insurance
IJK Corp.

I want to put a function the column in front of this list. This colum
would have to say "INS" in case it finds the "word" INSURANCE in thi
list. "CORP" if it finds "Corp." and so forth.

Can anyone assist? Thank you

Sac
 
Hi
try something like
=IF(ISNUMBER(Find("Corp",B1)),"Corp",IF(ISNUMBER(FIND
("Ins",B1)),"Ins","Other"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using a 'string inside a string' test inside a formula 5
Formula for extracting text formated numbers within ( )'s as numbe 5
DataGridView...really don't understand !!! 3
Problems Loading Large String Array into Array variable 6
JET ERROR - JOHN VINSON or anyone else who can assist 1
Black ops: how HBGary wrote backdoors for the government (Part 2) 0
Can't Ping My Own IP Address - Part 2 3
OpenOffice.org Newsletter (02/2004) 3

Back
Top