Ask Your Question
0

Extract/Filter cell text from pattern. [closed]

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-23 08:15:24.616875

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

Question Tools

1 follower

Stats

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

Seen: 78 times

Last updated: Jul 23 '15