ersing one letter in a cell
 

Hi,

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

Thanks

ersing one letter in a cell
 

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)

On Wed, 28 Jan 2009 06:04:01 -0800, Ksenija
wrote:

Hi,

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

Thanks

ersing one letter in a cell
 

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:


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)

On Wed, 28 Jan 2009 06:04:01 -0800, Ksenija
wrote:

Hi,

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

Thanks

ersing one letter in a cell
 

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)

On Wed, 28 Jan 2009 06:35:01 -0800, Ksenija
wrote:

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:


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)

On Wed, 28 Jan 2009 06:04:01 -0800, Ksenija
wrote:

Hi,

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

Thanks