I have a row which contains various text and need a formaula to rename the
text to smaller groups

If it equals "filters" then "non fuel"
if it equals "oil", then "fuel"

This information will be tallied in a cell in the same spreadsheet running
the length of the sheet say cell z3 through z6000

thanks

Use EDITreplace

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Curtis" wrote in message
...
I have a row which contains various text and need a formaula to rename the
text to smaller groups

If it equals "filters" then "non fuel"
if it equals "oil", then "fuel"

This information will be tallied in a cell in the same spreadsheet running
the length of the sheet say cell z3 through z6000

thanks

Assuming text is in cell A1

=IF(A1="FILTERS","FUEL",IF(A1="OIL","NON-FUEL"))



"Curtis" wrote:

I have a row which contains various text and need a formaula to rename the
text to smaller groups

If it equals "filters" then "non fuel"
if it equals "oil", then "fuel"

This information will be tallied in a cell in the same spreadsheet running
the length of the sheet say cell z3 through z6000

thanks

a little more help please

=IF(T3="Heavy Duty & Equipment Customers",IF(T3="Retail
Customers","Commercial","Retail NON-Gas"))

"Don Guillett" wrote:


Use EDITreplace

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Curtis" wrote in message
...
I have a row which contains various text and need a formaula to rename the
text to smaller groups

If it equals "filters" then "non fuel"
if it equals "oil", then "fuel"

This information will be tallied in a cell in the same spreadsheet running
the length of the sheet say cell z3 through z6000

thanks

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Curtis" wrote in message
...
a little more help please

=IF(T3="Heavy Duty & Equipment Customers",IF(T3="Retail
Customers","Commercial","Retail NON-Gas"))

"Don Guillett" wrote:


Use EDITreplace

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Curtis" wrote in message
...
I have a row which contains various text and need a formaula to rename
the
text to smaller groups

If it equals "filters" then "non fuel"
if it equals "oil", then "fuel"

This information will be tallied in a cell in the same spreadsheet
running
the length of the sheet say cell z3 through z6000

thanks