Retrieving the a string from a sentence

[superkid]

=IFERROR(SEARCH("[",string,1),MID(string position,start of char,length of char))

Hi I wish to pull out the characters from a sentence. Once it detects the "[" from the sentence it should pull the string that follow limiting to the length of the character.

It looks like I did something wrong and the results shows only the position of "[" only.

I want to error check because it to return nuthing if there's no value. IF statement would process errors in this case.

Any help to get this right.
thanks

[JBeaucaire]

Show us some sample strings and clarify what you want out of those examples.

[DonkeyOte]

A few things:

1 - please PM a Moderator to have your thread moved a more appropriate Forum (Worksheet Functions)

2 - IFERROR is only available in 2007, your profile implies you're running 2003 in which case I'm afraid you can't use it

I think perhaps you mean:

=IF(ISNUMBER(SEARCH("[",string,1)),MID(string,SEARCH("[",string,1)+1,LEN(string)),"")

string should obviously be a cell reference

[superkid]

I apologize for posting in the wrong forum and will pm the moderator.

My system was just upgraded to the 2007 system. Btw I am having problems uploading the sample worksheet.

Thank you .

[DonkeyOte]

To use IFERROR here just adapt that provided to:

Please Login or Register  to view this content.

[superkid]

thank you

but this will return the length of the string right But i would like to get the content from the string.

For example
i went to the [see,saw] to play.

Expected result should return see,saw
The function should detect the braces and enter the value and nothing when it does not detect the braces.

[DonkeyOte]

The prior function would not return the LEN - please have the courtesy to test solutions before dismissing.

As is it also helps to state your question as clearly as possible... you make no mention of ] in your initial post, to get your desired results:

Please Login or Register  to view this content.

Where A1 is your string.

If you're using the above to retrieve a filename from a path you can obviously insert CELL("filename") as opposed to A1.

[superkid]

Thank you so much. Got it running. I admit it was my mistake. I subtracted the length of the string wrongly.

Please Login or Register  to view this content.

Thanks a millions.

[arthurbr]

Thread moved as requested by OP