copy select characters from specified cells.

[Guest]

I'm trying to build on an answer I received last week (which was very
helpfull).

I'm using the below formula to conditionally copy the data from the fourth
cell over - or leave the field blank if the word 'Named' is not in the 4th
column.

=IF(ISNUMBER(SEARCH("[ Named",C[4])),C[4],"")

I need to expand on the copy portion as I need to conditionally copy the
contents of C[4] and to always ignore the first 20 characters and the last 2
characters from C[4].

example input from C[4]:
[ Named Symbology - T_Flow Line CBC ]
000Default LineLineSymbology
001Default TextTextSymbology

[ Named Symbology - T_Flow Line of Stream>River ]
000Default LineLineSymbology
001Default TextTextSymbology

 

[Guest]

Try this...
=IF(ISNUMBER(SEARCH("[ Named",C[4])),mid(C[4],21,LEN(C[4])-21-2+1),"")
untried formula.
HTH,

 

[Guest]

=IF(ISNUMBER(SEARCH("[ Named",C[4])),mid(C[4],21,LEN(C[4])-21-2+1),"")

 

[Guest]

Works like a champ! I was not aware of the mid function. Thank you!!!

=IF(ISNUMBER(SEARCH("[ Named",C[4])),mid(C[4],21,LEN(C[4])-21-2+1),"")
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.

I'm trying to build on an answer I received last week (which was very
helpfull).

I'm using the below formula to conditionally copy the data from the fourth
cell over - or leave the field blank if the word 'Named' is not in the 4th
column.

=IF(ISNUMBER(SEARCH("[ Named",C[4])),C[4],"")

I need to expand on the copy portion as I need to conditionally copy the
contents of C[4] and to always ignore the first 20 characters and the last 2
characters from C[4].

example input from C[4]:
[ Named Symbology - T_Flow Line CBC ]
000Default LineLineSymbology
001Default TextTextSymbology

[ Named Symbology - T_Flow Line of Stream>River ]
000Default LineLineSymbology
001Default TextTextSymbology