Auto-ID and Delete/left shift cells when a cell contains text?

I

IndyToothDoc

I routinely produce Excel spreadsheets with data exported from my SQL
database. I need to automate "cleanup" in a couple areas.

The most challenging (for me) is the when the SQL database has multiple
client notes, that client's row in Excel has multple cells- one for each
note. As you can imagine, it shifts over all the data to the right, so a
column that would otherwise contain something like client email has data from
a different column.

I have been manually delete/left-shift-cells for each client. Obviously
this takes time and is prone to mistakes.

I need a way to "automate" a way to clean up excess cells. I want to either
merge a group of text cells into one cell, or delete/left-shift the cells.


Is there a way for Excel to look down a column, know that it should only
contain a number- not text- and automatically delete/left-shift the cell? I
figure if I can do that, I can make a macro out of it and automate data
cleanup.

Please Help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top