How can I find the paragraph on Excel?

Develop
1

Hi everybody, It’s good to join the community :smiley:. I got a 50 columns and rows Excel file. And I tried couple of ways like the loop (wasting too much time), VBA (do not know how to code).

So is there any fast way to find the paragraph (output must be on cell reference output)?

Or maybe if someone can give me good link to learn VBA? Thank you!

2

Hi Michael,

Have you converted your file to datatable? If you did and your file have less than 1000 rows, use foreach row is easiest way to work with that. For more than 1000 rows, may VBA or linq is better. Here is an example
Screenshot 2023-03-13 090430