View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.