Hi,

If all you want to do is extract data in a cell to the right then I wouldn't
use a macro, it's overkill.

With your data in Column D put this in the column to the right and drag down.

=MID(D1,SEARCH("+",D1)+1,LEN(D1))

As to how to get here, use a newsreader or as I do this address
http://www.microsoft.com/office/comm...ang=e n&cr=US

Mike

"L'il Ginny" wrote:

I have two questions: 1-i'm trying to create a very simple macro that will
extract certain text from a cell and move it to the cell to the right. The
full text is L+300...i want to copy just the 300, and move it. I want to do
this for a column of cells that contain L+###. I've read posts that say the
edit function doesn't work with macros (which, by the way is NEVER mentioned
on excel help...), so how do you "get into" the cell to do this? Also, i've
tried to use the cell reference tool on the 'stop record' toolbar with no
success. HOw does this work, exactly? do you reference the target cell or
the original? neither worked...
2- (stupid question) is there a way to enter this discussion area directly
w/o going thru excel's help function (like, is there a direct web address?)