Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
Most effective method would be to use a macro.
Since you don't specify what "some cases" are here is example code which will append to every cell in a selection. Sub addtext() For Each cell In Selection cell.Value = cell.Value & "()""," Next End Sub Gord Dibben MS Excel MVP On Tue, 26 May 2009 09:08:01 -0700, Matt A. wrote: I have a 1000 row worksheet using 12 columns. Each cell is filled with an individual word used in the english language. In some cases I need to add a ( ) " , to words in each cell. Any hints on the most effective way to do this for multiple cells at the same time? Thanks much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
=SUM((C2:C7000="Friday")*(F2:F7000="8:00:00 AM")) not adding | Excel Discussion (Misc queries) | |||
Formating numbers &"Text" to appear as currency &"Text" in formula | Excel Discussion (Misc queries) | |||
"Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
How do I use "offset" function in "array formula"? | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |