asked on Remove blanks from a string of numbers
Folks,
I have many numbers such as the one below where I need
13 04 2012
to be this
13042012
I have many numbers such as the one below where I need
13 04 2012
to be this
13042012
Microsoft Excel
Last Comment
Frank Freese
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Already answered, but just in case...
If the cell entries are actually date values, then you could just format the cells with the following custom format:
DDMMYYYY
(rather than DD MM YYYY)
Please note that will also have the advantage of leaving the cell values as valid dates (from excel's perspective).
HTH,
Alan.
If the cell entries are actually date values, then you could just format the cells with the following custom format:
DDMMYYYY
(rather than DD MM YYYY)
Please note that will also have the advantage of leaving the cell values as valid dates (from excel's perspective).
HTH,
Alan.
ASKER
That Alan
Appreciate EE