M$ Excel

[Urendi Maleldil]

Is there a way to reverse concatenate something?

[Suicide Junkie]

You mean to take a substring?

[Trajan]

There is the text to columns option, but that would require you to have some kind of delimiting character such as a space or a comma or tab.

I am not sure about being able to use a FCN to do it, though I am long since past my prime Excel days.

Cheers!

[geoschmo]

I am pretty sure a macro could do it, but those aren't my area of expertise. It might be possible with a simple formula. I'll have to play a bit and see if I can figure out a way.

Geoschmo