I have a dataset of about 5000 rows, in it there are product codes of varying length, i just want to filter the 4-digit numbers. Unfortunately the numbers are in text format because some begin with zero's. Anyone got any ideas?
Chris
I have a dataset of about 5000 rows, in it there are product codes of varying length, i just want to filter the 4-digit numbers. Unfortunately the numbers are in text format because some begin with zero's. Anyone got any ideas?
Chris
Use the formula =LEN(Cell Ref) where Cell Ref is the cell reference of the product code, this will return a value equal to the number of characters in the product code, then do a filter for the 4
I'd use a column of helper cells:
=--A2
and drag down.
Then filter by that column.
Custom|is greater than 999.
The -- converts the text numbers to number numbers.
cj21 wrote:
>
> I have a dataset of about 5000 rows, in it there are product codes of
> varying length, i just want to filter the 4-digit numbers.
> Unfortunately the numbers are in text format because some begin with
> zero's. Anyone got any ideas?
>
> Chris
>
> --
> cj21
> ------------------------------------------------------------------------
> cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
> View this thread: http://www.excelforum.com/showthread...hreadid=391277
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks