Remove Phone Numbers from data

Hi

Good days

I have excel file where i Need remove Phone number from the data

There are 2 sheets in excel file

1. Sheet "Data" where raw data will have here
2.Sheet "Output" data after process

I have attached the sample data


Thanks
Rj

See if this is how you wanted.

Please Login or Register  to view this content.

=SUBSTITUTE(E2,0&MAX(IFERROR(--MID(SUBSTITUTE(E2," ",REPT(" ",LEN(E2))),ROW(1:1000),LEN(E2)),0)),"")

Ctrl + Shift + Enter
copy down