Ask Your Question
0

Extract/Filter cell text from pattern.

asked 2015-07-22 19:11:04 +0100

shmykis gravatar image

updated 2015-08-24 09:34:35 +0100

Alex Kemp gravatar image

Hey Guys,

First of all, I want to appologize for my English. :)

I would like to get your suggestions on how to filter the values I need and remove the rest from the cell in another cell.

To make this more clear here are few examples:

I have this line in Cell F1:

4 CARTUCHOS COMPATIBLE NON OEM EPSON T1285 T1281 T1282 T1283 T1284 NO ORIGINAL

and I need to get in Cell H1:

T1285 T1281 T1282 T1283 T1284

(from the line above).

Basically what I need is to extract/filter (I hope I'm using the correct term) pattern:

TXXXX

from all the cells in the F columns.

Thank you for the help,

Cheers,

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2015-07-23 11:37:36 +0100

pierre-yves samyn gravatar image

Hi

The Extract.ods describes a solution.

Regards

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-07-22 19:11:04 +0100

Seen: 72 times

Last updated: Jul 23 '15