| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is a string while merging
What is it and how do I do it?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
| counting the number of instances of a string within another string | Excel Worksheet Functions | |||
| Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
| to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
| When merging information not merging correctly | Excel Worksheet Functions | |||
Linear Mode
