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