how to get sub strings using delimiter

**abhimaan** · 05-30-2012, 02:43 PM

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 !!!

**vandan_tanna** · 05-30-2012, 02:49 PM

for the text in A1:

=LEFT(A1,FIND(" ",A1)-1)

**abhimaan** · 05-31-2012, 08:48 AM

Thanks for the reply Vandan, but I am getting error on this.
It says FIND function not defined.

**jraj1106** · 05-31-2012, 08:57 AM

Hi

Try this:

=TRIM(LEFT(A1,FIND(" ",A1)))

**vandan_tanna** · 05-31-2012, 10:31 AM

I am surprised because the find function is available in excel 2003 - you indicate in your profile that you have excel 2003.

try replacing search with the find function as follows:

=LEFT(A1,SEARCH(" ",A1)-1)

if it still doesn't work, let me know and we can request others to look at it.