Hi
I have an address field and i need to split into 2 columns, but i need to do this at the 2nd space i.e.
flat 21 the avenue
i need column A= flat 21 and column B= the avenue
has anyone got a formula that will do this (no macros please i am not that clever)
I have an address field and i need to split into 2 columns, but i need to do this at the 2nd space i.e.
flat 21 the avenue
i need column A= flat 21 and column B= the avenue
has anyone got a formula that will do this (no macros please i am not that clever)