Inserting text in column dependant on another column

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Hi all,

I'm using Excel 2000 and am trying to extract data to display on a
graph. What I have is a string of text in capital that includes either
INT, EXT or INIT within it - When an instance is found INT, EXT or INIT
is put into the next column (same row).
i.e if text in A1 contains INT, INT will be written in B1

I've been wrestling with IF THEN ELSE to try to achieve this but I've
got nowhere :(

Can someone please help?

Dave
 
Formula or macro. Is the text inside other text
xxxxxxxINTxxxxx or by itself INT
 
Don said:
Formula or macro. Is the text inside other text
xxxxxxxINTxxxxx or by itself INT
Click to expand...
I'm trying to come up with a formula, the format of the text is XXXX INT
XXXX XXXX
 
=IF(NOT(ISERR(SEARCH("int",C6))),"INT",IF(NOT(ISERR(SEARCH("def",C6))),"DEF",IF(NOT(ISERR(SEARCH("xyz",C6))),"Xyz","")))
 
Don said:
=IF(NOT(ISERR(SEARCH("int",C6))),"INT",IF(NOT(ISERR(SEARCH("def",C6))),"DEF",IF(NOT(ISERR(SEARCH("xyz",C6))),"Xyz","")))
Click to expand...
Thank you so much :) That works brilliantly

Dave
 
Dave -

This works in Excel 2003, and I imagine it will in Excel 2000:

=IF(ISERR(FIND("INT",A4)),IF(ISERR(FIND("EXT",A4)),IF(ISERR(FIND("INIT",A4)),"","INIT"),"EXT"),"INT")

The FIND is case-sensitive, so if the INT, EXT, or INIT might be lower-case,
then you may want to use SEARCH instead of FIND.
 
Back
Top