CODEWITHSUNDEEP
excelvba
nagu samineni
nagu samineni

Reputation: 9

how to remove space between letters in EXCEL?

I have few numeric columns which I got from a website and copied directly into Excel.

In those columns there is a SINGLE Leading space at the beginning of each number in the cell of the entire column.

try provide vba or any excel formula

Upvotes: 0

Views: 94

Answers (2)

Robby
Robby

Reputation: 827

This should work.

Sub RemoveSpaces()
Selection.Replace " ", ""
End Sub

Upvotes: 1

Dominique
Dominique

Reputation: 17493

Did you try using the Trim() worksheet function?

Upvotes: 1

Related Questions