LinkBack URL
About LinkBacks
Dear all
i would like to remove space in excel colums
Example:
if number is 3 705,490 ,i would like to keep it like this : 3705,490
I try TRIM,CLEAN ,Replace space and same problem
Thank You
Dear all
i would like to remove space in excel colums
Example:
if number is 3 705,490 ,i would like to keep it like this : 3705,490
I try TRIM,CLEAN ,Replace space and same problem
Thank You
Try:
Formula:
Please Login or Register to view this content.
Or to convert it to a number:
Formula:Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
this is my example in attachement ,you can check it
i test with 2 solution that you provide but same problem
welcome to the forum. try:
=--SUBSTITUTE(A1,CHAR(160),"")
those spaces you have are called non-breaking spaces. they are not your regular spaces. usually found when download from somewhere
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thank You ,it s working
Originally Posted by benishiryo
-----
I have the same issue but the data is a mixture of characters and integers - is there a similar solution
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks