Thread: How do I append the same text to multiple cells?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mike herman mike herman is offline
external usenet poster
  
Posts: 1
Default How do I append the same text to multiple cells?
I want to add a "" to each cell in a column of cells when the cell isn't
blank. I'm doing this in a macro for multiple workbooks, so I want the
fastest/most efficient way possible.

My current idea is:
Given the column with text is column A, insert a new row with the formula
=IF(T(A2)<"",""&A2,"") and drag that formula down, then paste special
values over into the location I want the data.
Is there a better way?
Reply With QuoteReply With Quote