Thread: how insert same text in empty cells in column (10000 rows)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bromptongadgets
 
Posts: n/a
Default how insert same text in empty cells in column (10000 rows)
a column with 10,000 rows - 90% of them are empty. I want to put the same bit
of text in every empty cell without pasting or extending the range 1000
times. Can I identify cells which are empty and put the same text in them?
Reply With QuoteReply With Quote