View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Paste text- help

hi,
I don't think you can. but you can use a formula.
=CONCATENATE(A1,B1) Copy down.
adjust to your data.
to change formula to hard data, editpastespecialvalues (at A1). delete
other data.

Regards
FSt1




"Anand vijay" wrote:

Hi..

I want to know that if in cell A1 to A20 I have some text and i want to pase
addtional text in the existing text in all the cells from A1 to A20 . How do
I do it in one command.