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

Delete "+" character in last cell
 

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

Delete "+" character in last cell
 

there are a couple ways,
here's one, just change the range to your needs. i added a ' so you could keep
the entire number.


Sub test()
Dim cell As Range
For Each cell In Range("A1:A200")
cell.Value = "'" & Left(cell.Value, 18)
Next

End Sub


--


Gary


"Ledge" wrote in message
oups.com...
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