Adding " , ) to text array
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.
|