I realise this is not the place.... But my recordset is nearly 1 million. So Access would be the easiest way forward.
I have tel numbers containing all sorts of spaces, dashes etc,in one column. I want to run an update query to an empty column which removes blanks and dashes leaving the tel no as a the numbers
ie 01253-202121 would be 01253202121
This is in order that I can lookup and match on telno from another list. Any help would be appreciated
I have tel numbers containing all sorts of spaces, dashes etc,in one column. I want to run an update query to an empty column which removes blanks and dashes leaving the tel no as a the numbers
ie 01253-202121 would be 01253202121
This is in order that I can lookup and match on telno from another list. Any help would be appreciated