selecting text

  • Thread starter Thread starter 25jump
  • Start date Start date
2

25jump

I need to select only the cells with text colunm N with text in them
 
Select column N
Edit>Go to>Special, click Constants and check only Text (under Formulas)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

function for last non-blank entry in column? 2
Wild Card / Character 4
number formatting 3
formula to search and find item sheet1 copy to sheet 2 1
Count cells if next column has text 2
Remove certain characters from a text string 6
excel formula needed 3
Access Textbox - Hide Cursor 0

Back
Top