Thread: [Solved] remove character in a cell
View Single Post
 
Old 03-12-2020, 05:02 PM
cefd1 cefd1 is offline Windows 10 Office 2019
Novice
 
Join Date: Jul 2019
Posts: 10
cefd1 is on a distinguished road
Default remove character in a cell

I have a worksheet that has data listed examples: 9-2 - Washington and 9-2-30 - Washington.

Is there a code that removes the last hyphen between the numbers and beginning of letters that I could drag down my column for a large worksheet?

Thanks
Reply With Quote