var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Extract text before the space
Hello all, Good morning.
I am trying to generate a job number out of some values in columns. Values look like this : 051502-003502 MP
As you can see that value contains Dash and space. What i am trying to do is capture only the numbers before the space. So it would be 051502-003502.
How can i do this? I have tried using the Format Function. But its not doing anything. Need some help on this
Left([Column], Instr([Column], " ") - 1)
Have a nice day!