rid hidden info in a cell

  • Thread starter Thread starter Bill Camp
  • Start date Start date
B

Bill Camp

I have a 2 column array. First column [the problem]
contains hidden info that does not allow this array to be
used in a 'vlookup' function. The second column is
okay,and contains only a single digit number.
How do I get rid of [delete] the hidden info in all the
cells of the First column, so this array may be used in
a 'vlookup' ?
 
This newsgroup is not for help with programming issues, but for help with
the Help & Support centre in Windows XP. You should take your question to
one of the microsoft programming newsgroups. If it's VB, there are plenty
of VB newsgroups on the server...

Lorne
 
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

Shape Arrays VBA 0
Excel Comparing two columns 1
Excel Excel Vlookup formula based on cell data 7
Hidden text in tables causes empty rows 0
Can't Explain N/A in Vlookup 2
Need array formula to ignore hidden values 1
Excel Trying to do a vlookup with a nested right function on the array 3
Use & with two formulas 2

Back
Top