I have Zoho Enterpise

I created a filter in listview ,showing my "not correct phoneformat"

It is now 491234567 and

should be

+49-1234567

So I have sheetview and in column next to the wrong phone I created a colomn

PhoneOK, being a FORMULA like

="+"&MID(D2,1,2)&"-"&MID(D2,3,15)

and so I get the correct Format :   +49-1234567


NOW COMES MY PROBLEM:

I need to copy the "formula"column next to a column  PhoneOK

but that is not easy, I exce​ed the 100 rows  and how to insert the NEW format into my ZOHO ?


How to solve this ?


Thanks

Wim Rippen

Netherlands