| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merge content of cells
Hi! I have a long list of codes that I want to in an application. In order to
use the code in the application I must add a piece of text to the code. Eg the code is GB0032785924 And I must add the text €ś Govt Isin€ť. Thus the cell must contain exactly the text €śGB0032785924 Govt Isin€ť. How is this possible to do in the worksheet? I tried mergin two cells but that only resulted in one cell being left. Please help! Many thanks in advance! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Merge content of cells
=A1&+$B$4
Assuming the values are in the cells A1 and the fixed end code is in B4 Mike "Arne Hegefors" wrote: Hi! I have a long list of codes that I want to in an application. In order to use the code in the application I must add a piece of text to the code. Eg the code is GB0032785924 And I must add the text €ś Govt Isin€ť. Thus the cell must contain exactly the text €śGB0032785924 Govt Isin€ť. How is this possible to do in the worksheet? I tried mergin two cells but that only resulted in one cell being left. Please help! Many thanks in advance! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Merge content of cells
You can use a helper column filled with formulas like:
=a1&" Govt Isin" Where A1 contains the original code. Arne Hegefors wrote: Hi! I have a long list of codes that I want to in an application. In order to use the code in the application I must add a piece of text to the code. Eg the code is GB0032785924 And I must add the text €ś Govt Isin€ť. Thus the cell must contain exactly the text €śGB0032785924 Govt Isin€ť. How is this possible to do in the worksheet? I tried mergin two cells but that only resulted in one cell being left. Please help! Many thanks in advance! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge Cells | Excel Discussion (Misc queries) | |||
| Use the Merge & Center Button with unprotected Cells - sheet prote | Setting up and Configuration of Excel | |||
| Create Excel Grouping according to Merge Cells | Excel Worksheet Functions | |||
| Why can't I merge cells in Excel? | Excel Discussion (Misc queries) | |||
| Spreadsheet won't let me merge cells. plse help. | Excel Discussion (Misc queries) | |||
Linear Mode
