If and right formulas

Microsoft Office 2007 professional (aca...
February 4, 2010 at 10:39:52
Specs: Windows XP
COLUMN E CONTAINGS DIFFERENT ACCOUNT NUMBERS.EX. 640000-000-810-05
I WANT THE FORMULA TO LOOK AT THE LAST 6 NUMBERS CONTAINING 820-05, 830-05, 840-05,ETC IF TRUE = REMOVE IF FALSE = ""

See More: If and right formulas

Report •


#1
February 4, 2010 at 10:54:27
Are you asking for help or just telling us what you want?

Before you respond, please turn off your caps-lock feature.


Report •

#2
February 4, 2010 at 10:57:10
Yes, I need with a formula to fit this need.

Report •

#3
February 4, 2010 at 11:19:09
To put it a little more blunty, it's common practice to actually ask for assistance, typically by tossing a "please" in there somewhere, instead of just telling us what you want or need.

In any case, you said:

NUMBERS CONTAINING 820-05, 830-05, 840-05,
ETC IF TRUE = REMOVE IF FALSE = ""

First, the etc makes it a little hard for us to know what numbers to remove. etc up to what? Are we counting by 10's to some final value? Are we looking for all numbers ending in -05? Only numbers in the 800's that end in -05?

Please be a little more specific as to what strings you are looking for.

In addition, you said IF TRUE = REMOVE IF FALSE = ""

In my mind, if I remove something, I'll get "".

Again, we need a little more clarification.


Report •

Related Solutions


Ask Question