Hi All
I am a relative novice when it comes to VBA - I probably know enough to be spreadsheet dangerous.
All I am trying to do is clear the contents of cells in a column - All whole numbers but leave certain text+Numbers in a cell.
The data is fluid so changes each week - apart from the 1st row.
So in my example - I do not want to touch column A, In column B I want to delete all numbers but Leave the words Bas1, Bas2 Bas3 Bas4 in the cells they are in.
I have done a lot of searches and trials but not got what I need - Apologies if this is simple.
Bookmarks