Left and right

[Markm-s]

I have a column with values of 1a to 1d up to 10d, and i need it splitting
into the number part and letter.
The letter is easy as a Right(String,1) but for the number I can't see to be
able to work it out. Is there a way of finding out the length of a string?

Thanks Mark

 

[scubadiver]

You need the "left" function and the "mid" function. Do a search on "text
parsing" and the "mid" function and you should find an answer.

 

[Douglas J. Steele]

Left(YourString, Len(YourString) - 1)

 

[fredg]

I have a column with values of 1a to 1d up to 10d, and i need it splitting
into the number part and letter.
The letter is easy as a Right(String,1) but for the number I can't see to be
able to work it out. Is there a way of finding out the length of a string?

Thanks Mark

Well, the number part is
=Val(String)

The letter part is
=Right(String,1)

The length of the string (which you do not need for your purposes
here) is
= Len(String)