truncating

Hello all, As the title mentions, I am trying to remove all numbers at the end of a cell. Not every cell ends in a number and most of the time each cell contains numbers. These number are useless for our purposes and need to be deleted, datasets typically are received around 10k - 100k cells...

hi, i wanted to write a macro that would truncate the cell B1 to 10 character from the right. Then rename the sheet with the right bit of the cell. And finally delete both cells. And repeat this process with all sheet in the workbook (they all contain a section number and section description in...

I have a VBA macro which extracts data and formats it for printing. To the print format I have added a left header containing a text string showing the description of the data, and a left footer which contains a reference number. I have also included in the right footer the current date and...

Hi all, I currently have a Excel Sheet, that looks similar to this, Name | Tel | Divison | Email | ShortName | Mail Server On the Tel field, the information populated from a Lotus notes DB appears as follows: <TABLE style="WIDTH: 141pt; BORDER-COLLAPSE: collapse" cellSpacing=0...