List of strings after wildcard search

[Shaan2021]

Hello,

I have a spreadsheet that contains various filenames. I want to prepare a list of filenames that have the extension .txt

I can do a wildcard search in findall using *.txt and get all the filenames. However, this search points to cells that contain the .txt files. Along with the filenames, these cells also contain additional data.

Is it possible to strip out the remaining string data and just get a list of *.txt filenames?

 

[Dannyh1]

Hi,

Can you post an example?

 

[Shaan2021]

Data is in cells A7 to A12 as below.

a.txt
b.txt is not good
c.txt is very nice
d.txt is off for a walk
e.lbl
f.lbl


Go to Edit-->Find-->Findall and in the search box type *.txt
You will get a list of results with references to entire cells A7 to A10.

However, I am expecting just a list like
a.txt
b.txt
c.txt
d.txt