Adeline is a tech enthusiast who loves exploring the latest tools and applications in the marketplace. She also loves her Android and spends time reviewing apps and playing games when she has the time.
Reader Interactions
Comments
Vernessa Taylorsays
Hello Eddie,
Your Excel series is wonderful! I use both Excel and OpenOffice Calc (as well as Gnumeric in Linux) and your tips seem to work for Calc and Gnumeric, too. Thanks!
Thank you for the above answer on how to remove the excess spaces. Now, I’ve got a question about how to make that new column of space-less data into a useable column of data and not just of a formula. What I’d like to do is be able to replace the old column of data with this new column without all the spaces. Can it be done?
Good lesson, I never knew there was a “trim” function and I thought I knew excel well… This would have come in handy during many a project in my past… I’m seeing it a little too late, but will likely use it in the future
Hello Eddie,
Your Excel series is wonderful! I use both Excel and OpenOffice Calc (as well as Gnumeric in Linux) and your tips seem to work for Calc and Gnumeric, too. Thanks!
What about spaces in numbers? If I want to convert something like this:
703784 1394850 00330 7
to:
7037841394850003307
Is there a way to do it?
Use find & replace
find space & replace with blank
Kim you could use the function substitute to find the space and replace it with non space.
for instance: =SUBSTITUTE(A1;” “;””)
Thank you for the above answer on how to remove the excess spaces. Now, I’ve got a question about how to make that new column of space-less data into a useable column of data and not just of a formula. What I’d like to do is be able to replace the old column of data with this new column without all the spaces. Can it be done?
Good lesson, I never knew there was a “trim” function and I thought I knew excel well… This would have come in handy during many a project in my past… I’m seeing it a little too late, but will likely use it in the future