Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
removing blank cells from a column | Excel Discussion (Misc queries) | |||
Removing trailing spaces from cells ? | Excel Worksheet Functions | |||
Removing ' character from cells | Excel Discussion (Misc queries) | |||
Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
background formatting across multiple cells | Excel Discussion (Misc queries) |