M mayhem New Member May 1, 2015 #1 Dear Chandoo What's the best formula to split a cell by case. In the below example, how do I separate 15 Potts St from RYDE NSW 2112. 15 Potts St RYDE NSW 2112 Thank you
Dear Chandoo What's the best formula to split a cell by case. In the below example, how do I separate 15 Potts St from RYDE NSW 2112. 15 Potts St RYDE NSW 2112 Thank you
N NARAYANK991 Excel Ninja May 1, 2015 #2 Hi , See if this works on other data. Narayan Attachments Book1.xlsx 8.3 KB · Views: 0