Hi guys,
Assuming I have a concatenated strings with different length but with the same separator..
To illustrate: I have company code+ledger+asset code but with "-" in between.. This 3 do not have the same length..
Assuming here are my data
1. 111-123456-12456
2. 1111-1234-124
3. 11-12345-234
How can i get the mid character using the mid formula.. What i did was this formula:
MID(Concatenated string, FIND("-", Concatenated string), LENGTH(Concatenated string))
But i am not getting the mid characters only.
Appreciate your help!
Thanks,
Elaine