EXTRACTPHONENUMBERS issue

[Dan_Oliphant]

I have a field with the name and phone number of a worker. Dan: 5555555555. i used the extractphonenumber in a VC which returns a list. Is there any way to make the new virtual column a phone instead of a LIST. Because I am trying to add an action to use the value to call, but it throws an error.

[LeventK · Accepted solution]

Try enclosing the expression with a CONCATENATE(…) i.e. CONCATENATE(EXTRACTPHONENUMBERS(...))

[Dan_Oliphant]

LeventK:

CONCATENATE

Thanks! it worked!

[LeventK]

You’re welcome