View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ledge Ledge is offline
external usenet poster
 
Posts: 13
Default Delete "+" character in last cell

Hi all,

I am having a bit of trouble trying to remove the "+" sign from the
last cell with data in column A.

Column A is variable in terms of how many rows of data are present but
the number format is always 18 digits and the "+" sign

I have modified some macros found here to find the last cell ok but I
am lost on how to delete the "+" sign from the last cell only.

Would appreciate if someone could point me in the right direction.

Regards,
Dean

My data is set out like this:

HHxxxxx+
000000001100000001+
000000001100500001+
000000001101000001+
000000001102000001+
000000001102500001+
etc
etc
etc