View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
roy.okinawa
 
Posts: n/a
Default Add/Replicate Text In Cell Entry

I have something like this "5314RY89" entered in the first row in column B.
It will not be the same number in every cell. There are about 250 rows so
far. I need to add "WONO" at the beginning of each entry so it will show
"WONO5314RY89"

How can I replicate/add the WONO without doing each cell individually.