Hi All,
My data is supposed to look a certain way ( see below)
I need to remove spaces between D, the ID # (for example DXH110817) and the last name Doe.
I'm trying to find an efficient fast way of doing this since I have about 50 records in my data.
Any suggestions?
So right now, it looks like this:
<tbody>
</tbody><colgroup><col><col><col><col></colgroup>
My data is supposed to look a certain way ( see below)
I need to remove spaces between D, the ID # (for example DXH110817) and the last name Doe.
I'm trying to find an efficient fast way of doing this since I have about 50 records in my data.
Any suggestions?
So right now, it looks like this:
D | DXH110817 DOE JOHN | ||||||||
D | RXP011916 DOE JANE | ||||||||
D | 173616018 DOE JAKE | ||||||||
But it should look like this:
<tbody> </tbody><colgroup><col><col></colgroup> |
<tbody>
</tbody><colgroup><col><col><col><col></colgroup>