Quick Excel forumla problem

babs

Can't get enough of FH
Joined
Dec 30, 2003
Messages
1,595
I have a big spreadsheet which sadly I had to convert from an .rtf file. The problem is the database that produced the rtf document for me used tabs as a delimiter, and if one cell in any row is empty, it simply inserts a large tab to the next.

The problem this gives me is that if a cell is empty in the spreadsheet, all remaining data in that row is shifted one cell to the left which messes it up. Now the column which has the missing data only has 2 states which is handy (Yes, No) and obviously is sometimes blank. What I need is a formula similar to a vlookup one (array formula?) whereby it scans each cell in tha column and if it doesn't equal Yes or No it inserts a cell (shifting data to the right).

I can't imagine there's an easy formula to do it, but is there a simple macro or function?

Thanks in advance.
 

Users who are viewing this thread

Top Bottom