Search & Replace InString

Hi all,

I'm having somewhat of a difficult time trying to put some code together to
search for a string of characters matching a specific arrangement.

The specific arrange would be any numerical value followed by an alpha character.
such as: (1abc,12abc,123abc, 1234abc, 1234nabc....) n= any numeral of any length
abc = any alpha string of any length.

I'd would like to start the search from the LEFT(1abc,1), and for the only the
first case found,

the a space " " needs to be put between the numeric and alpha characters.
such as: (1 abc,12 abc,123 abc, 1234 abc, 1234 nabc....)
I don't know if these would be easier using a "case select" code
or something like

Please Login or Register  to view this content.

...above code not working.

Any help is appreciated.

Thanks,

BDB

You could try logic like this.

Please Login or Register  to view this content.

Formula approach

Please Login or Register  to view this content.

Thanks guys, but something is still not right.

mrice, The code as is did not change anything. I've been trying to figure out what's not right with it. Yet to correct.

Here's another attempt which does nothing.

Please Login or Register  to view this content.

Forum Guru, I'm not real sure how I would apply the formula to my code.
If you can supply some code that I could use, then I'd be more than happy to try it.

BDB

Hello BDB,

This is quite easy to do using Regular Expressions. Here is an example.

Please Login or Register  to view this content.

Hello BDB,

Do you want the modified text from the TextBox to be transfered to a worksheet cell or just displayed in the TextBox?

The modified text needs to be transferred to a worksheet cell.

Please Login or Register  to view this content.

Thanks,

BDB

Hello BDB,

This should work. Try it out and let me know what happens. The contents of the text box will remain unchanged, but the worksheet cell will show the corrected text.

Please Login or Register  to view this content.

Hello BDB,

The code to create the RegExp has to be a standard module. Here is the code now. These changes have been made to the attached workbook.

Module1 Code

Please Login or Register  to view this content.

CommandButton2 Code

Please Login or Register  to view this content.