Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
Appending data from two sheets according to like fields | Excel Discussion (Misc queries) | |||
appending fields from another spreadsheet | Excel Discussion (Misc queries) | |||
Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
Catalogue of fields' connection whit external fields ( sheets) | Excel Programming |