Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If 5th character="-" delete everything to the left otherwise do no | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
I need to count occurr. of the character "," in a single cell | Excel Worksheet Functions | |||
Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming |