I need to clean a database

[Guest]

I have rows without any data in them throughout my database. Can I do a
simple function to delete the empty rows between my data to clean up my list
in excel.

Second question, on the same database I have an column that consists of name
address city and zip. Is there a way to run a formula to separate these
values into their own rows.

 

[Pete_UK]

Highlight column A and click Data | Filter | Autofilter. From the
filter pull-down, select Blanks. Then highlight row 2, hold down
<Shift>, press <End> followed by <Down-arrow>, then release <Shift>.
Click Edit | Delete Row, then select All from the filter pull-down. You
might want to remove the filter.

If you have spaces separating each item, then you could highlight the
column and use Data | Text-to-columns, specifying a space as the
delimiter. Ensure that you don't have any data in columns to the right
of the one highlighted. This is not foolproof, however, as you may have
some entries with 2 and others with 3 names, or some addresses with 2,
3 or 4 words (each of which will go into a new column).

Hope this helps.

Pete