Can you use an excel function to isolate part of a text string?

[CharCat]

Hi everyone

I'm stuck. I have about 28,000 data points, and two columns. In the first column, the cells contain unique identification numbers; in second column, each cell contains a text string with lots of different information. I've been trying (and failing) to isolate just one part of the text string.

The problem is that part of the text string I'm trying to isolate is not always in the same place in the text string. Frustratingly, this means the "text to columns" approach will not work.

Ideally, I would like to isolate the one part of the text string, and then copy it into yet another column. Any ideas?

Here's an example of what I'm working with:

10201007B W2 E2 SEC 35 23 23 160AC
10201007J SWSW SEC 35 23 23 40.00AC

[vlady]

If you could post a sample workbook on that maybe someone could offer a solution. also include the expected outcome. from above you didn't state the "part" to be isolated.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Regards,
Vladimir

[CharCat]

I'm trying to isolate the area information, e.g. the "160AC" and the "40.00AC."

[CharCat]

[ATTACH]183155[/ATTAC

I hope this works

[Ace_XL]

Try...

=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",100)),100))

[CharCat]

thank you but that doesn't seem to work