Ask Your Question

Search & copy sentences containing #

asked 2019-11-18 22:52:45 +0100

NoLogo gravatar image

I'd like to search & copy all rows starting with a # in a big .ods document.

Can this be done using a macro?

edit retag flag offensive close merge delete


What do you mean exactly by rows starting with a #? Do you mean by that "the first character in the first column of a row is a #"?

And to copy is one thing, but without paste the data are lost in memory. So the question is: You want to copy whereto? (new table1, same table new line at the end, into a new file).

Opaque gravatar imageOpaque ( 2019-11-19 01:02:54 +0100 )edit

Hi, There is only text/sentences in the first column of each row. There are 8838 rows to search through.

I need to copy (only) the first column rows if the first character of the text is a #

NoLogo gravatar imageNoLogo ( 2019-11-19 11:02:10 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-11-19 18:21:28 +0100

erAck gravatar image

Select/mark your first data column. Go to menu Data -> More Filters -> Standard Filter, from Condition select Begins with, in Value enter # and under Options enable Copy results to, enter a cell reference you want to start the output at, e.g. Sheet2.A1, hit OK.

edit flag offensive delete link more


That worked perfectly! I now have a list of just the lines starting with # Thanks for your help: you're my hero :-)

NoLogo gravatar imageNoLogo ( 2019-11-19 21:17:46 +0100 )edit

Please, if the answer solves the question click ✔.

m.a.riosv gravatar imagem.a.riosv ( 2019-11-19 21:56:22 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-11-18 22:52:45 +0100

Seen: 62 times

Last updated: Nov 19 '19