Quote Originally Posted by gregddd1 View Post
The number of text strings to process is randomly positioned in different areas of the spreadsheet. Having to constantly edit the formula for each newly positioned text string slows me down considerably. I'm looking for a point and copy solution that negates the use of editing the formula due to a different cell address for the text string.
You should start over here, then. You asked a too simple question. Also, you should consider some control on your end as well...saying you might have text strings separated by a variety of characters is unnecessarily complex, don't you think?

To be able to "point" at anything and get a string of numbers would most likely:

1) be a VBA solution
2) require you to decide in advance all the different ways your two numbers will be separated and note them all so the macro can be trained
3) decide in advance where these outputs are supposed to go each time you activate the macro

Layout a full set of criteria and we'll try again. But think it all through, we're not on a design team here, we want to help but not drag this out forever, so a good complete set of criteria, method, end results...speed this whole thing along.

Perhaps you can upload a sheet demonstrating ALL the variations you have to deal with, all the various places they might be, etc, and we can suggest something specific.

Click GO ADVANCED and use the paperclip icon to post up your workbook.