ersing one letter in a cell

K

Ksenija

Hi,

Can somebody tell me how I can erase the first letter in i cell? How do I
write that code?

Thanks
 
C

Chip Pearson

With code, use

Dim S1 As String
Dim S2 As String
S1 = Range("A1").Text
S2 = Mid(S1,2)

Or, with a formula,
=MID(A1,2,LEN(A1))

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
K

Ksenija

Hi again,

it's not working.. maybe I formulated my question badly. I have a cell in
wich it written <6. I want to write a code that takes away "<"..






"Chip Pearson" skrev:
 
C

Chip Pearson

Just add

Range("A1").Value = S2

after the S2 = Mid(..) line.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Top