Help with Excel

[pedruid]

I used to know how to do this but have forgotten.
I have created a spreadsheet of TV Series and when I have burned to disc I put Y in the column. I need to weed out the ones that are <> Y. Any help greatly appreciated.

 

[PaCiFieR]

Highlight all you columns. Click the DATA tab, Click FILTER, on the Column with your "Y", click the drop down and only select "Y"

 

[pedruid]

Thank You.

 

[Wall]

Didn't want to start a new thread... please can you help

I need to extract the email address from a cell. The formatting is below:

[email protected],,,1,soft

A comma always follows the email address. how can i extract the email address?

 

[Cray]

Didn't want to start a new thread... please can you help

I need to extract the email address from a cell. The formatting is below:

[email protected],,,1,soft

A comma always follows the email address. how can i extract the email address?

Use this formula...

=LEFT(A1,(FIND(",",A1,1)-1))

Assuming your data is in cell A1..

Alternatively you can use text to coloumns with a "," as a delimiter...

 

[PsYTraNc3]

Text to columns with comma delimitation will put the email address in one cell.
Data tab > Text to columns