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

Improving Macro That Keeps First Letter 0
Outlook 365 overriding formatting choices 0
Keep First Letters, with exceptions 0
Paste to excel from word - auto format problem 1
Problem with MS Word paragraph and character styles: format getting messed up 2
triming the first 10 characters in a cell.. 2
Delete characters from behind if too many 8
VBA office 365 on windows 10 0

Top