View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] edgetown70@gmail.com is offline
external usenet poster
 
Posts: 7
Default Q to Automate Removal of Characters from Cells

I am looking for a piece of VBA that will remove all characters/spaces to the left of the minus sign. All values are in Column D. I could have data in any Row between 2 & 500, of any value

Example is
" EURO -491.15

So I just want it to appear in cells as
-491.15