Removing all spaces from a row of Excel using VBA

Question

I am trying to remove all spaces (both beginning, end, middle, and anywhere else they may be) from each cell in row 3 of Excel. So far I have been able to successfully trim the rows, but that only removes a space at the end.

Could someone help me develop a VBA code that can remove all spaces from the entire row?

Here's what I have so far:

Sub Trim()
    [3:3] = [if(3:3<>"",trim(3:3),"")]
End Sub

SJR · Accepted Answer · 2019-07-01 19:04:55Z

6

How about

Rows(3).Replace " ", ""

answered Jul 1, 2019 at 19:04

SJR

23.1k6 gold badges21 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

SJR Over a year ago

Trim specifically does not remove single spaces between words.

Collectives™ on Stack Overflow

Removing all spaces from a row of Excel using VBA

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related