Sundance_Kid
Board Regular
- Joined
- Sep 2, 2017
- Messages
- 130
- Office Version
- 365
- Platform
- Windows
Hi there, I have a list of names and numbers all in one with a hyphen separating the name and number. I want to remove the number & hyphen.
Bill Clinton - 1234
Joe Biden - 5678
So, basically all the above appears in a cell & I want to just see it appear like :
Bill Clinton
Joe Biden
Can someone advise on how best to formulate it to remove the hyphen & number from the excel cell.
Thanks
Bill Clinton - 1234
Joe Biden - 5678
So, basically all the above appears in a cell & I want to just see it appear like :
Bill Clinton
Joe Biden
Can someone advise on how best to formulate it to remove the hyphen & number from the excel cell.
Thanks