View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Les Stout Les Stout is offline
external usenet poster
 
Posts: 10
Default Left Function in code

Hello,

I have got a number that i need to split using code. Could somebody
please help me out.

it is always in this format 1234567-00

and i need to split it by the first 7 "1234567" in one column and then
the last two "00" in another column.
The minus "-" can be lost.

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!