Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting text in column dependant on another column
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting text in column dependant on another column
Formula or macro. Is the text inside other text
xxxxxxxINTxxxxx or by itself INT -- Don Guillett Microsoft MVP Excel SalesAid Software "Dave" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting text in column dependant on another column
Don Guillett wrote:
Formula or macro. Is the text inside other text xxxxxxxINTxxxxx or by itself INT I'm trying to come up with a formula, the format of the text is XXXX INT XXXX XXXX |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting text in column dependant on another column
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. -- Daryl S "Dave" wrote: 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dependant Data Validation - for Whole Column | Excel Worksheet Functions | |||
create a list dependant on info in a column | Excel Worksheet Functions | |||
Copy a column dependant on a the contents of a cell | Excel Worksheet Functions | |||
Sum/average numbers in column A dependant on value in column B | Excel Worksheet Functions | |||
How to add numbers in a column dependant on their colour | Excel Worksheet Functions |