-3
I have a spreadsheet of 7 thousand lines and I need to remove the space between the numbers. I tried to use the function ARRUMAR or TRIM but it didn’t work.
On the spreadsheet it’s like this:
11 99999999
I need you to stay like this:
1199999999
Is there a function that does this? I’m not finding :{
0
Good afternoon,
You can use the Find and Select, On the Home tab in the Editing group
Or use a formula: =REPLACE(A2; "Sales"; "Cost") Example: Replaces Sales by Cost (Cost Data)
Thank you.
By the "Find and Replace" I am not succeeding, I put the for example "11 " (without quotation marks) and it does not find. How would I use this to replace for 7,000 lines?
Here it worked. I selected the column and applied the locate and replace exactly as you did and said it does not find.
@Lucky no locate you put the space and in the subsitute nothing.
0
To remove spacing use the SUBSTITUIR if the installation is available.
Ex:
=SUBSTITUIR(E7;" ";"")
The ARRUMAR is only for spaces before and after, between words it does not process.
Strange that is not removing the spaces, I even downloaded a business called "Kutools" that has a function to remove all spaces, but does not work. :(
Beware of using double wings and not simple.
Browser other questions tagged excel
You are not signed in. Login or sign up in order to post.
Before anything, start by doing the tour to understand how the community works; then read the How to ask to check how you can improve your question and finally access help center to check various articles that will help you better understand the site.
– Gustavo André Richter