Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change 3 letter text string to a number string Pete Excel Discussion (Misc queries) 3 December 31st 07 07:47 PM
counting the number of instances of a string within another string Keith R Excel Worksheet Functions 3 March 5th 07 06:54 PM
Splitting a text string into string and number mcambrose Excel Discussion (Misc queries) 4 February 21st 06 03:47 PM
to search for a string and affect data if it finds the string? Shwaman Excel Worksheet Functions 1 January 11th 06 12:56 AM
When merging information not merging correctly Bridgett Excel Worksheet Functions 0 December 9th 05 10:12 PM


All times are GMT +1. The time now is 09:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"