Thread: help to remove space before the data
View Single Post
  #8   Report Post  
Mazzaropi Mazzaropi is offline
Senior Member
  
Location: Belo Horizonte, Brazil
Posts: 170
Thumbs up
Quote:
Originally Posted by Ricky Martin View Post
I have a problem, how to remove the spaces before and after the figure number.
two days I've searched but have not found the answer.
thank you
ricky
Ricky, try to do this:

B1 -- MID(A1,2,4)

Copy down to the other cells.
Please, tell me if it worked for you.
__________________
I hope it can help you.

Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil
Reply With QuoteReply With Quote