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?