ersing one letter in a cell

  • Thread starter Thread starter Ksenija
  • Start date Start date
K

Ksenija

Hi,

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

Thanks
 
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)
 
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:
 
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)
 
Back
Top