Insert value from another cell AND text

[calibansfolly]

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?

 

[PCLIVE]

You could use a formula in a different column.

Example: In B1:

="text" & A1 & "text"

Then copy this formula down as needed.

HTH,
Paul

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[Rick Rothstein \(MVP - VB\)]

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