View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Amon Borland Amon Borland is offline
external usenet poster
 
Posts: 1
Default Appending to fields

I have a 400 row column called zipcode. Obviously, it contains 400
different zipcodes. For each record, I need to append or concatenate some
punctuation to it.

Zipcodes look like this 12345, I want each one to look like '12345',

That is, adding paranthesis around the number, and a comma after each
number.

Any easy way to do this?

Thanks for the help!