hi,

i want to copy the part of the string in a particular cell to another sheet.

e.g. the string is cell A1 is as below:

EVENT_ID NUMBER(10) NULL

In the above string I want to copy the sub-string EVENT_ID and paste it to another worksheet.

Can anyone help me out in getting the first substring i.e EVENT_ID in the above given space delimited string or is there any function available which directly given me the first sub-string of the given string.


Thanks in advance !!!