blank cells that include text

[Cally]

Help!
I have been trying to use functions to get information from particular
columns of an excel spreadsheet. The unfortunate part is that due to the way
the original information was input the information I want in each row is in
different columns.

a) I thought about doing a non-text function as an intermediary but although
certain cells are blank it appears that I have to go in and do a manual
delete of every cell. I can't choose an area because they are not in a
block. Can anyone suggest a way to automatically ensure that blanks cells
are considered non text?

b) is there a function, or a series of functions that will help me to choose
the last cell in a row that has text and then input the data in that cell
into a new cell so that I have one discrete column of text?

 

[David McRitchie]

Hi Cally,
I don't think you have provided any information to describe your
problem; therefore, it is hard to offer suggestions for any solution.

Based on the subject title I might suggest that formulas regardles
of value are not empty so will never test as ISBLANK in Excel
nor as ISEMPTY. in VBA.

If you want to MOVE entire columns around see
http://www.mvps.org/dmcritchie/excel/fillhand.htm#cursor

If you want to delete rows or cells see
http://www.mvps.org/dmcritchie/excel/delempty.htm

 

[Cally]

Hi its me again, If anyone is reading this I have found the answers by
looking on some previous requests. I copied a macro that someone provided to
re-enter cell data (after changing all the cells to general format, rather
than text), then a formula that was available for finding the last text
reference in a row.

Thankyou to the people who provided these responses to previous queries as
you have just saved me about 5 days worth of manual changes. And hitting my
head against a brick wall as well.

 

[David McRitchie]

Hi Callyl
I'm certainly pleased to hear you found your own answer, and told us so.
Though I can relate to some of what you say you found it is also too sketchy,
but the fact that you found your answer in previous postings is certain to
produce the most comprehensive results and better results than you would ever
get even in a whole week.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
..