Get certain texts from words in exel

[hendrikbez]

I have a imported document in excel, that has quit a lot of characters, I want to get certain characters out form it

1025500550610014884000000000101004500010336052200000325844000000000000Autopax 002001600000000000Rale Sebudi 00000000000000000000000000000000000000000000000000000000000000000

I want to get This (00000325844) and this (Rale Sebudi) to be displayed.

I did try Left and Right to take out, but cannot get it to do middle and other characters.

[ragulduy]

try MID(), to get text from the middle of a string. I often use it in combination with FIND() to help get positions to start the mid function at.

[newdoverman]

If and only if the characters are in the same position in the string of characters, these two formulae will extract the desired text.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[hendrikbez]

Thank you, the mid() is working