Im trying to remove unneeded duplicate data in a single column from multiple rows. Each cell in the column title Phone number says "Phone Number: xxx.xxx.xxxx Fax Number: xxx.xxx.xxxx" where I only need it to say "xxx.xxx.xxxx" (Just the phone number) What is the quickest way to update 243 cells
Solved by O. E. in 27 mins