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