I have a phone number in a excel cell e.g. 1-234-567-7890 but in a web page same number is populated as (234) 567-7890
I want to match both values so that it can pass results.
1- is replaced by (
and after 3 digits of string we have )
what approach I should follow.
input is 1-234-567-7890
output should be (234) 567-7890