Are the 23 digits of useless information always in the same position in the
field? Like always at the end or beginning or is it random?

Also, what is in the field? Is it exclusively the 15+23 digits? or is there
other information? If the data is stand-alone and always in the same
position you can use the LEFT or RIGHT formulas to only pull in what you want.