Il giorno giovedì 21 febbraio 2013 20:53:47 UTC+1, Ricky Martin ha scritto:
how to remove the spaces before and after the figure number.
+-------------------------------------------------------------------+
|Filename: Pro.JPG |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=769|
+-------------------------------------------------------------------+

Hi Ricky,
try:
1. Select range
2. Data Text to Columns
3. (.) Delimited [Next]
4. [v] Space [Next]
5. (.) Do not import column (skip) [Finish]
--
Ciao!
Maurizio