ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What is a string while merging (https://www.excelbanter.com/excel-discussion-misc-queries/195486-what-string-while-merging.html)

Sarah

What is a string while merging
 
What is it and how do I do it?

Pete_UK

What is a string while merging
 
A string is another word for Text - a string of characters. If you
have two strings in A1 and A2 and want to join them together (merge,
or concatanate), you can put this formula in another cell:

=A1 & A2

and the result will be the two strings merged together.

Hope this helps (with your homework ?)

Pete



On Jul 19, 12:25*am, Sarah wrote:
What is it and how do I do it?



Tim879

What is a string while merging
 
you can also use the concatenate formula.... does pretty much the same
thing.


On Jul 18, 8:15*pm, Pete_UK wrote:
A string is another word for Text - a string of characters. If you
have two strings in A1 and A2 and want to join them together (merge,
or concatanate), you can put this formula in another cell:

=A1 & A2

and the result will be the two strings merged together.

Hope this helps (with your homework ?)

Pete

On Jul 19, 12:25*am, Sarah wrote:

What is it and how do I do it?



Gord Dibben

What is a string while merging
 
If you like more typing<g


Gord Dibben MS Excel MVP

On Fri, 18 Jul 2008 19:22:04 -0700 (PDT), Tim879 wrote:

you can also use the concatenate formula.... does pretty much the same
thing.


On Jul 18, 8:15*pm, Pete_UK wrote:
A string is another word for Text - a string of characters. If you
have two strings in A1 and A2 and want to join them together (merge,
or concatanate), you can put this formula in another cell:

=A1 & A2

and the result will be the two strings merged together.

Hope this helps (with your homework ?)

Pete

On Jul 19, 12:25*am, Sarah wrote:

What is it and how do I do it?




All times are GMT +1. The time now is 02:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com