removing unnecessary spaces from multiple cells
I have many cells where the numbers have a space or two after each one. I am
not able to format them as numbers because of this and don't want to have to remove them manually. I have tried the Replace with but don't know how to have it remove spaces. It says I must have a value. Thanks. |
removing unnecessary spaces from multiple cells
If the "numbers" are all in 1 col,
think we could give Data Text to Columns a try Select the col of "numbers" Click Data Text to Columns Click Finish -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "sflady" wrote in message ... I have many cells where the numbers have a space or two after each one. I am not able to format them as numbers because of this and don't want to have to remove them manually. I have tried the Replace with but don't know how to have it remove spaces. It says I must have a value. Thanks. |
removing unnecessary spaces from multiple cells
In a helper column, =value(trim(a1)). The trim deletes spaces on either end
and the value converts it back to a number. Autofill, then copy / paste special values to fix the results, then delete the original column. "sflady" wrote: I have many cells where the numbers have a space or two after each one. I am not able to format them as numbers because of this and don't want to have to remove them manually. I have tried the Replace with but don't know how to have it remove spaces. It says I must have a value. Thanks. |
All times are GMT +1. The time now is 04:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com