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...and.htm#cursor

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

---
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

"Cally" wrote in message ...
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?