Mid function to return part of String

If a$="H123456" how could i get B$ to = a without the H.

So in other words drop the first chr

=mid(a1, 2, 32766)

Please use thread titles that are more descriptive of your problem.

Hello stoney1977,

Here is another way...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

or......

=REPLACE(A1,1,1,"")

It just occurred to me these are VBA string variables:

Please Login or Register  to view this content.