There are many excel books for sale by several on this list. Goto your
computer store or hang around here and learn. Practice and the macro
recorder are your friend.

--
Don Guillett
SalesAid Software

"Gordon" wrote in message
...
Thanks very much ... got it to werk just fine

Is there is a manual for this that is for beginners like me ... the help
in
excel is next to useless for me ...

Regards,

Gordon

"Don Guillett" wrote in message
...
You did NOT post your efforts.

Sub strip5()
For Each c In Selection
c.Offset(0, 1) = Left(c, Len(c) - 5)
Next
End Sub

--
Don Guillett
SalesAid Software

"Gordon" wrote in message
...
Thanks for your help ...

I got the first one to work just fine but the 2nd one is giving me
trouble
...

for/each macro with c.value=Left(c,len(c)-5)

I was getting an error when I coppied that into the macro

any further suggestions ??

Regards,

Gordon

"Don Guillett" wrote in message
...
question 1. use activecell.offset(1,0).select to go down one. But you
do
NOT
need to select cells in excel to do something to them. Use
activecell.offset(1).value="Lotus"
question2 use a for/each macro with c.value=Left(c,len(c)-5). Post
yours
for
comments

--
Don Guillett
SalesAid Software

"Gordon" wrote in message
...
Hi

I would like to know how to set a macros similar to the ones I used
in
Lotus
... for Example

In Lotus when I moved around when setting a macro it would just go
up
and
down ... no matter where I start from ...
In excel ... it references specific cells to go to ... how do I just
move
up
or own with out going to a specific cell in an Excel macro??

Second .... I had an editing macro in Lotus where I could go to the
end
of
a cell and delete the last five characters and then go to the next
cell.
when I try to do that in Excel ... it relaces the whole line with
the
one
I
used in the macro ... How do I change the macro to just delete the
last
five
characters of each cell and then go on to the next cell ...

Thanks

Gordon