I NEED 6 LETTERS WITH USE OF LEFT()

[BHUVANESH]

I HAVE A Column name [Design NO]=10015 A

i am using fn LEFT([DesignNo],6)...but Result Shows 10015..not show 10015 A....

plese any one find solution

[TeeSee1]

There seems to be a space between the number part and the alphabet...

May want to use SUBSTITUTE() to delete any spaces..

[Uk]

Hi, this may help you = LEFT(substitute([DesignNo]," ",""),6)

substitute  to erase any spaces = "" to " "