| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I insert two lines of text into one cell? | Excel Discussion (Misc queries) | |||
| Insert colon in text in cell | Excel Discussion (Misc queries) | |||
| Need a macro to insert text in a cell that already has text.Excel | Excel Discussion (Misc queries) | |||
| Insert Text From Different Cell | New Users to Excel | |||
| How to insert text into a cell | Excel Discussion (Misc queries) | |||
Linear Mode
