| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
append column data
I have the following:
COL1 COL2 COL3 COL4 SP000008 COVS S&IH EN and need this displayed in COL5 SP000008_COVS_S&IH_EN.html |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
append column data
Assuming each column will have an entry and that, unlike your posted message
looks, there will not be extraneous blank spaces before or after an entry... E2: =A2&"_"&B2&"_"&C2&"_"&D2&".html" If there can be extraneous blank spaces, then use this instead.... E2: =TRIM(A2)&"_"&TRIM(B2)&"_"&TRIM(C2)&"_"&TRIM(D2)&" .html" Rick "ACarella" wrote in message ... I have the following: COL1 COL2 COL3 COL4 SP000008 COVS S&IH EN and need this displayed in COL5 SP000008_COVS_S&IH_EN.html |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
append column data
=A1&"_"&B1&"_"&C1&"_"&D1&".htm"
"ACarella" wrote: I have the following: COL1 COL2 COL3 COL4 SP000008 COVS S&IH EN and need this displayed in COL5 SP000008_COVS_S&IH_EN.html |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
append column data
=A1&"_"&B1&"_"&C1&"_"&D1&".html"
Gord Dibben MS Excel MVP On Tue, 22 Jul 2008 08:04:04 -0700, ACarella wrote: I have the following: COL1 COL2 COL3 COL4 SP000008 COVS S&IH EN and need this displayed in COL5 SP000008_COVS_S&IH_EN.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| append worksheet with data from another | Excel Worksheet Functions | |||
| how do i append old and new data in excel | Excel Worksheet Functions | |||
| Auto append data | Excel Discussion (Misc queries) | |||
| How do I append same text to all the cells in a column at once? | Excel Worksheet Functions | |||
| How do I append data in several cells in one column | Excel Discussion (Misc queries) | |||
Hybrid Mode
