deleting first 10 characters in a cell
 

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

Thank you

deleting first 10 characters in a cell
 

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

deleting first 10 characters in a cell
 

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))

--
Rick (MVP - Excel)


"dstiefe" wrote in message
...
how do i delete the first 10 characters in a cell? and so there are not
10
spaces in the cell?

Thank you

deleting first 10 characters in a cell
 

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