Grabbing Text_characters

[Ben Ball]

I have a text field which contains numbers, text etc.. for example.

"012345","GB","012","045658","testing"

I need to be able to grab a part of that text. Which will always be the same length of characters and always in the same position.

so for example I need to extract the "045658" from the text field and have that part based on starting as the 21st character in that field..

is there a way to do this?

FYI This information has been imported from XL and I need to seperate a part of the fields.. the fields in XL are not seperated. just as a csv..

TIA

[mr_vodka]

Look into the Middle () function.

[Ben Ball]

Perfect.. thanks..