Remove spaces in Excel
Solved
T10
-
Al95 -
Al95 -
Hi,
I have a list of 3 columns
Column A = Name
Column B = Address
Column C = Locality
In the first row, all the names start with a space in each cell.
Is there a formula to automatically remove this space
because there are still 3500 lines and if I have to do them one by one...
Thank you
I have a list of 3 columns
Column A = Name
Column B = Address
Column C = Locality
In the first row, all the names start with a space in each cell.
Is there a formula to automatically remove this space
because there are still 3500 lines and if I have to do them one by one...
Thank you
8 réponses
It's even simpler!
You select all the cells where there is this issue, then Ctrl + H
"Replace" and in the first line "Find what" you press the spacebar and in the 2nd "Replace with" you put absolutely nothing...
"Replace All" and voila, no more spaces... =)
You select all the cells where there is this issue, then Ctrl + H
"Replace" and in the first line "Find what" you press the spacebar and in the 2nd "Replace with" you put absolutely nothing...
"Replace All" and voila, no more spaces... =)
Lol
This solution works well, but it removes the spaces between words.
chalex92
Posted messages
3
Status
Membre
1
Thank you very much Niels, it’s simple and quick ;)
