Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to fill only empty cells in a database with a symbol.
I'm working with a database that requires first and last name for import. I
have all the last names but some of the first names are missing and will get kicked out of the import. Normally, I type a . in the first name cell and that works. However, I was hoping I could select the entire first name column and fill only the cells that are empty with a . That would be a big time saver as I'm currently dealing with about 1250 empty column cells. Is that possible? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill cell value to the next empty row | Excel Discussion (Misc queries) | |||
Fill-in empty cells from SAP report | Excel Worksheet Functions | |||
Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
When I SUM cells & 1 is empty I need the result to be empty not 0 | Excel Discussion (Misc queries) | |||
How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) |