Left$ and Right$ and Mid$ and other string operators are "left over" from the
days of BASIC. Ron and Jon have explained their use quite well. LEFT, RIGHT
etc are late comers to the world.

As you note, James, there is no LEFT$, RIGHT$, MID$ for the worksheet
itself, just in the innards of VB.

"James Silverton" wrote:

Andy wrote on Sat, 5 May 2007 05:25:00 -0700:

A Can someone explain the difference between the two of these?
A Thanks!

I don't seem to have LEFT$ in Excel 2002. When did it appear or
disappear? There *is* LEFTB that refers to double byte
characters like Chinese ones.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not