Dear Friends,
How can I split mixed data (Text & Numbers) into 2 seperate columns? For example the following data is in Cell A1 and I would like to split Numbers into Cell A2 & Text into Cell A3.
501054 ROYAL SUPPLIERS
605423 SRUJANA MARKETING AGENCIES
Note: First 6 characters are numbers then one single space and the text has variable characters.
Thanks in advance.
Bookmarks