deleting first 10 characters in a cell

  • Thread starter Thread starter dstiefe
  • Start date Start date
D

dstiefe

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

Thank you
 
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
 
Not a lot of description there about what is actually in the cell). Maybe
this way (assuming you want to do this for the active cell)?

ActiveCell.Value = Trim(Mid(ActiveCell.Value, 11))
 
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
Mikes’s VBA solution, the same cell can be manipulated.
 
Back
Top