» Joining text using formula in Microsoft Excel
Much like writing a formula to join text, as described, the Concatenate function allows you to merge values from multiple cells into a single cell.
In a formula, you create a space between words by pressing the Spacebar.
In the second box in sample figure, pressing the Spacebar will automatically add the quotation marks when you move to the next box.


Book Store:
Recommended Books:
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- The Fall of Advertising and the Rise of PR
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Special Edition Using Microsoft Access 2002
Copy the formula down to the end of the range.
When finished copy and paste special_values
You now have the value from column A and the suffix.gif in text



I am trying to see if there is a way to join two different colums of text into on colum? I am trying to populate my web store with these products from my distributor. One colum has the product name such a ARG12 and then the second colum has "noimage.gif" but I changed "noimage.gif" to just ".gif" now if i could only find a way to merge or joing these two colums, then the image names would all be easily imported (there over 2000) and having to manually type a ".gif" after each one would take forever...There must be a way to merge two colums of text? or a way to easily do this so that i end up with ARG12.gif in one colum?
Anyone?
Thanks,
-taylor reaume
Loopwise.com
tre@loopwise.com
AIM Y! MSN loopwisechat