I have a Character on Excel Character 09 and need to deleted and split the cell in two do they have a formula how to split it, is a company name and Address together....

Please need Help.....