How to replace string and match with data

activities

#1

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


#2

Hi,
Here we go.
phoneNumber.xaml (12.0 KB)


#3

Thanku so much!! it works:slight_smile:


#4

@ddpadil, Is is feasible I can read a blank value from a cell in excel.

I have a sheet where in a cell nothing is written, i wanted to read that blank value.


#5

yes.
Read cell return empty value.