Can also use the MID function on the worksheet. However, ensure last
parameter is at least the number of characters to be returned (does not
matter if greater).

=MID(A1,11,255)

Or could use
=MID(A1,11,LEN(A1))
This will always ensure that the last parameter is large enough.

Note: The above formulas cannot be in same cell as source data (in these
examples Cell A1). Need to use another cell (helper column). However, with
Mikess VBA solution, the same cell can be manipulated.

--
Regards,

OssieMac


"Mike H" wrote:

Hi,

You posted in programming so in vb

Range("A1").Value = Mid(Range("a1"), 11)

or as a formula

=RIGHT(A1,MAX(0,LEN(A1)-10))

Mike



"dstiefe" wrote:

how do i delete the first 10 characters in a cell? and so there are not 10
spaces in the cell?

Thank you