deleting first 10 characters in a cell

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
 
M

Mike H

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
 
R

Rick Rothstein

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

OssieMac

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.
 

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

Similar Threads

triming the first 10 characters in a cell.. 2
Getting filename data 7
limit cell input 3
Macro that will insert a simple text string in top cell of text file 1
deleting text 3
Delete characters from behind if too many 8
First 3 characters 5
LEFT and MID 2

Top