Hi,
I need a formula to separate data from one column and show it divided in 2 columns. For example:
"1 LITTLE COLLINS STREET" is currently in Column A
The formula should show this as below:
Column B - 1
Column C - LITTLE COLLINS STREET
The issue is there are numbers of 1 digit, 2 digits, 3 digits etc. I need only one formula that will separate the street names from the Street numbers.
File is attached herewith. Thanks in advance for your support.
Regards.
Bookmarks