Dear All

I have in column E mix address with post codes
eg: Blythswood square
G12BG Glasgow

In the text the split between address and post code is by Enter

How can i split it into two columns F & G
I wne form data -- text to column but i do not know how to declare the
Enter symbol.
Any ideas?

Thansk in advance
Manos