I have one excel spreed sheet like 10001:F7110- first row, second row will
be like 10001:F7111-, third row will like 10001:F112-, how can I write
macro remove 10 and last - in this excel sheet.

Thanks.


Lillian

One way is to use a helper column with a formula in it:

=MID(A1,4,LEN(A1)-4)

Starts in column 4 and takes all the characters (except the last and the first
3)

If they all start with 10 and finish with dashes (and those strings don't
appear in the portion to keep), you could do:

Edit|Replace
what: 10
with: (leave empty)
replace all

and
edit|replace
what: -
with: (leave empty)
replace all





Lillian wrote:

I have one excel spreed sheet like 10001:F7110- first row, second row will
be like 10001:F7111-, third row will like 10001:F112-, how can I write
macro remove 10 and last - in this excel sheet.

Thanks.

Lillian

--

Dave Peterson