Range.delete method

T

Touk

Hi, I have a list of numbers about 6 characters in length
listed in a spreadsheet. I would like to delete the first
2 numbers that appear in the cell eg (217000 I want to
delete "21" so that only 7000 appears in the cell). Am I
able to use the Range.delete method to do this in VBA or
is there another way I can do this? After this is done I
can then easily filter that list. Please advise the
easiest way to do this.
 
M

Myrna Larson

For Each Cell In Selection
x = Cell.Text
Cell.Value = CDbl(Mid$(x, 3))
Next Cell
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top