Hi everyone,
i have a list, for example:
23
43
654.
34
123
656.
76
34.
43
See at the end of 34, 654 & 656 there is a "."? Its all good for the rest
How do I get rid of them? I tried using =clean(), with no luck...
Thank you!
Hi everyone,
i have a list, for example:
23
43
654.
34
123
656.
76
34.
43
See at the end of 34, 654 & 656 there is a "."? Its all good for the rest
How do I get rid of them? I tried using =clean(), with no luck...
Thank you!
Last edited by rhua5436; 09-30-2011 at 01:47 AM.
Hi rhua,
Are the cells of the format 'text' .. coz if the format is 'general' etc the "." wouldn't appear in the first place
hello
did you tried using =trim() before using =clean()
hi Johnrichie,
they are in text format... and i tried converting them into number format just then and its working now
dunno why they didn't work earlier when i tried similar operations (paste special > multiply by 1)
Thank you for your time!
Most welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks