If the characters are the same in all cells just editreplace

One cell at a time use a helper column with LEFT or RIGHT fumctions.

e.g. =RIGHT(A3,LEN(A3)-2) will remove first 2 characters from A3

With VBA you can probably delete from all cells at once.

Is the data to be removed consistent?

Do you have any sample data you could post?


Gord Dibben MS Excel MVP

On Thu, 20 May 2010 08:51:01 -0700, fazz
wrote:

is it possible to highlight multiple cells and delete characters from the
beginning of them?