Dean:

Dim rLast As Range

rLast = Sheet1.Range("A65536").End(xlUp)

rLast.Value = Left$(rLast.Value, Len(rLast.Value)-1)


--
Dick Kusleika
MVP-Excel
www.dailydoseofexcel.com

Ledge wrote:
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