| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I append the same text to multiple cells?
This should be very quick. Just select the cells and run the macro:
Sub mike() For Each r In Selection If IsEmpty(r.Value) Then Else r.Value = r.Value & "" End If Next End Sub -- Gary's Student gsnu200706 "mike herman" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Append multiple columns | Excel Discussion (Misc queries) | |||
| append multiple columns | Excel Discussion (Misc queries) | |||
| Append text | Excel Discussion (Misc queries) | |||
| How do I append same text to all the cells in a column at once? | Excel Worksheet Functions | |||
| How can you append text in multiple cells in excel? | New Users to Excel | |||
Linear Mode
