Thread: Concatenation
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default Concatenation

try....

Selection.Value = "123" & Selection.Value


--
Cheers
Nigel



"Biff" wrote in message
...
Hi Folks!

Trying to figure out how to concatenate a string to each cell in a range

of
cells.

I tried this:

Selection.Value = ""123"" & Selection.Value

Of course that did not work!

I guess VBA concatenation is different from worksheet concatenation.

Thanks!

Biff