Jeffrey Green
Well-known Member
- Joined
- Oct 24, 2007
- Messages
- 1,021
I have entries that look like this -
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
I need to remove the dashes. I find and replace all - with nothing. that has worked for YEARS. Seems simple to me.
Today, when I do it, Excel leaves the "300" and removes everything else. I even did a CLEAN function and it still does it.
This is killing me having to remove them one at a time.
Thanks
300-7188258-1</SPAN> |
300-8983980-5</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
I need to remove the dashes. I find and replace all - with nothing. that has worked for YEARS. Seems simple to me.
Today, when I do it, Excel leaves the "300" and removes everything else. I even did a CLEAN function and it still does it.
This is killing me having to remove them one at a time.
Thanks