» Joining text using formula in Microsoft Excel
CATEGORY - Keyboard Formula Shortcuts
VERSION - All Microsoft Excel Versions
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
Mergeing Cells
Brendan Posted on: 31-12-1969
The easiest way to do this is in a new column enter the formula =a1&".gif"
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
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
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