Matt40Forte
New Member
- Joined
- Jul 27, 2017
- Messages
- 3
Hey Everyone,
I have a list of data but the way the data is pulled there is sometimes spaces between the numbers like seen below. Does anybody know of an automated way where I could transfer these numbers into the adjacent column with the spaces removed? Any help is greatly appreciated.
[TABLE="width: 58"]
<colgroup><col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;"> <tbody>[TR]
[TD="width: 77, bgcolor: transparent, align: right"]3385880932[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]3385806850[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]3384245156[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]3385998218
[/TD]
[/TR]
</tbody>[/TABLE]
I have a list of data but the way the data is pulled there is sometimes spaces between the numbers like seen below. Does anybody know of an automated way where I could transfer these numbers into the adjacent column with the spaces removed? Any help is greatly appreciated.
[TABLE="width: 58"]
<colgroup><col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;"> <tbody>[TR]
[TD="width: 77, bgcolor: transparent, align: right"]3385880932[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]3385806850[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]3384245156[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]3385998218
[/TD]
[/TR]
</tbody>[/TABLE]