**Question description:**

*This user has given permission to use the problem statement for this
blog.*

I am looking to export part of an excel spreadsheet: only those lines that have some text in Column N. How do I do that please?

Solved by B. Q. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
07/11/2017 - 12:18

Hi, It's pleasure to help you today:)

User
07/11/2017 - 12:18

How do I create and insert a formula for exporting from an excel document only lines that have date in a certain line?

Excelchat Expert
07/11/2017 - 12:19

Can you please show me a sample in the preview.

Excelchat Expert
07/11/2017 - 12:19

With the help of filters, we can copy the data containing in column N.

User
07/11/2017 - 12:20

Let's say I want to export only lines that have hello in line F?

Excelchat Expert
07/11/2017 - 12:20

Ok. Normally, row 1 will be Titles and is called title row.

User
07/11/2017 - 12:20

The entire row would be exported IF there is date in F

Excelchat Expert
07/11/2017 - 12:21

So, select the data and apply filter

Excelchat Expert
07/11/2017 - 12:21

Now, from the filter, select all expect blanks

Excelchat Expert
07/11/2017 - 12:22

Now, you can copy the data by selecting and pasting it.

Excelchat Expert
07/11/2017 - 12:23

Please check in sheet 2

Excelchat Expert
07/11/2017 - 12:23

After copying the data, only data containing rows are appearing.

User
07/11/2017 - 12:23

Explain one more time. I select data "hello" and then?

Excelchat Expert
07/11/2017 - 12:24

select column N

User
07/11/2017 - 12:24

ok

Excelchat Expert
07/11/2017 - 12:24

and then apply filter

Excelchat Expert
07/11/2017 - 12:24

Please try step by step now

Excelchat Expert
07/11/2017 - 12:24

1) Select column F

Excelchat Expert
07/11/2017 - 12:25

2) Apply Filter

User
07/11/2017 - 12:25

where do you press apply filter?

Excelchat Expert
07/11/2017 - 12:25

It is available under Data menu, filter

Excelchat Expert
07/11/2017 - 12:25

It was already applied

Excelchat Expert
07/11/2017 - 12:25

3) click on the funnel symbol located in F1 cell

User
07/11/2017 - 12:26

How did you create that filter to begin iwth?

Excelchat Expert
07/11/2017 - 12:26

Please try again

Excelchat Expert
07/11/2017 - 12:26

1) select column F

Excelchat Expert
07/11/2017 - 12:27

2) Click on filter under Data menu

Excelchat Expert
07/11/2017 - 12:28

Hi, there?

User
07/11/2017 - 12:28

I'm confused please start again

Excelchat Expert
07/11/2017 - 12:29

Try adding some data in other column to understand better

User
07/11/2017 - 12:29

OK now how do I export all rows that have date in I?

Excelchat Expert
07/11/2017 - 12:29

1) select all columns that has data

Excelchat Expert
07/11/2017 - 12:30

That is from A to I

Excelchat Expert
07/11/2017 - 12:30

Can you please select

User
07/11/2017 - 12:30

how do I do that?

Excelchat Expert
07/11/2017 - 12:31

At the top you can see A B C D in grey colour select them together by just dragging your cursor

Excelchat Expert
07/11/2017 - 12:32

Select the top letter A that represents column A

Excelchat Expert
07/11/2017 - 12:32

Not the cell. You are in A1 cell

Excelchat Expert
07/11/2017 - 12:32

Can you see letter A at the top

Excelchat Expert
07/11/2017 - 12:32

click on that

Excelchat Expert
07/11/2017 - 12:33

The timer is running down.

Excelchat Expert
07/11/2017 - 12:33

Are you able to select it?

User
07/11/2017 - 12:34

ON A1?

Excelchat Expert
07/11/2017 - 12:34

on letter A, just below formula bar

Excelchat Expert
07/11/2017 - 12:34

or press ctrl A

Excelchat Expert
07/11/2017 - 12:34

it will select the whole data

Excelchat Expert
07/11/2017 - 12:35

or at the end junction of A column and row 1, there is a rectangular grey colour box

Excelchat Expert
07/11/2017 - 12:35

select that

User
07/11/2017 - 12:35

Got it!

Excelchat Expert
07/11/2017 - 12:35

Can you see fx?

Excelchat Expert
07/11/2017 - 12:35

below that there is a rectangular box in grey colour

Excelchat Expert
07/11/2017 - 12:36

Please try in preview

Excelchat Expert
07/11/2017 - 12:36

Please extend the session

User
07/11/2017 - 12:36

what is fx?

Excelchat Expert
07/11/2017 - 12:36

Are you able to select all the cells?

User
07/11/2017 - 12:36

yes

Excelchat Expert
07/11/2017 - 12:36

please extend the session

Excelchat Expert
07/11/2017 - 12:37

The timer is running out

User
07/11/2017 - 12:37

ok will do

Excelchat Expert
07/11/2017 - 12:37

I did not get any message

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*