MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copy a column of zip codes and trim the first digit


Posted by Paul B on February 11, 2002 3:53 PM

Is there a macro solution to copying a column and trimming the first character. I'm trying to create a 4 digit pass code from a list of zip codes.

Thanks - Paul.



Posted by DRJ on February 11, 2002 5:22 PM

Hi

You can use mid()

i.e. = Mid(A1,2,4) would give the characters in starting with the one in the second place and 4 chars total. Modify as needed.

HTH

DRJ