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!

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!

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