» Extract the last word in a cell in Microsoft Excel
CATEGORY - Excel Text , Excel Formula
VERSION - All Microsoft Excel Versions
Use the Following Function:
=RIGHT(A1,LEN(A1)-FIND("*",SUBSTITUTE(A1," ","*",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))
The result: Disneyland?
Book Store:
Recommended Books:
- Business Plans For Dummies®
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Special Edition Using Microsoft Excel 2002
- The Financial Numbers Game: Detecting Creative Accounting Practices
- The One Page Business Plan: Start With a Vision, Build a Company!
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
Taylor:
The Mace Posted on: 31-12-1969
you might want to concatenate or 'join' those cells. if you're just working with text files, its quite easy.
example:
you have "ARG12" in A1, and ".gif" in B1
=CONCATENATE(A1,B1)
this would result to: "ARG12.gif"
if all those texts are on just TWO columns, you'd want to use this formula instead so that excel can have a reference point:
=CONCATENATE($A1,$B1)
hope this helps.
The Mace
just-another-bum-on-this-planet
seek_me32@hotmail.com



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