Remove dup values in a cell (212) 555-12341234

[Concierge]

I have a spread sheet where the last 4 digits of the phone are duplicated in some records, looking like (212) 555-12341234. Is there a way to remove the last 4 digits of the incorrect numbers only?

 

[Matty]

Welcome to the Board!

So that we are able to provide a robust solution, could you provide a few more examples indicating the desired results the formula should deliver?

Thanks,

Matty

 

[dberg30]

if all of the phone numbers start the same way, with the area code in parenthesis, then you can do the following in a column next to all of the numbers:

  |------A--------------|------B-------|
1  (212) 555-1535         =LEFT(A1,14)
2  (212) 555-12341234   =LEFT(A2,14)
3  (212) 555-2213         =LEFT(A3,14)
4  (212) 555-15691569   =LEFT(A4,14)

Basically enter the formula =left(cell,14)