Insert value from another cell AND text
 

I have a list of several hundred zip codes in column A. I want to
insert text around them- before and after. It's the exact same text
for each cell. Anyone have an idea how this might work?

Insert value from another cell AND text
 

You could use a formula in a different column.

Example: In B1:

="text" & A1 & "text"

Then copy this formula down as needed.

HTH,
Paul

wrote in message
ups.com...
I have a list of several hundred zip codes in column A. I want to
insert text around them- before and after. It's the exact same text
for each cell. Anyone have an idea how this might work?

Insert value from another cell AND text
 

="text" & cellref & "text" entered in B1 and copied down.


Gord Dibben MS Excel MVP

On Thu, 28 Jun 2007 09:57:18 -0700, wrote:

I have a list of several hundred zip codes in column A. I want to
insert text around them- before and after. It's the exact same text
for each cell. Anyone have an idea how this might work?

Insert value from another cell AND text
 

I have a list of several hundred zip codes in column A. I want to
insert text around them- before and after. It's the exact same text
for each cell. Anyone have an idea how this might work?

You could custom format your column with this...

"Front Text "00000" Back Text"

Rick