lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I have phone number A1=111-222-3333, I want to replace "-" with nothing "", to get A1=1112223333 , so I thought substitute() will do the job if I write it like the following:
=substitute(a1,"-","",2)
I thought 2 means to delete both "-" in the text but it appears no, it will delete the second one.
I know I can use Find&Select-->Replace All, but I want to know if I can do it using substitute() function.
Thank you very much.
I have phone number A1=111-222-3333, I want to replace "-" with nothing "", to get A1=1112223333 , so I thought substitute() will do the job if I write it like the following:
=substitute(a1,"-","",2)
I thought 2 means to delete both "-" in the text but it appears no, it will delete the second one.
I know I can use Find&Select-->Replace All, but I want to know if I can do it using substitute() function.
Thank you very much.