On 24 Dic, 21:59, TomP wrote:
I have a string that captures text from a mainframe and would like to know
how to get rid of the underscores and spaces. *

Here's an example of what I have

Dim SMPL as String

SMPL = CurrentScreenObject.GetString (3, 30, 25)

Range ( "A14") = SMPL 'text is put on the spreadsheet

Here's an example of what would show up on the spreadsheet .....

___ TEXT


Hi Tom.
See:
http://www.tmehta.com/regexp/
Buon Natale
Eliano