Evening Folks,
Working on a database, and trying to get a formula to work on looking at a full post code and listing in another cell the shortened version.
i.e : EH54 5DZ, and showing in other cell just EH
I can do this with formula =LEFT,SEARCH("".L2,2))
But my problem is when I get a post code such as "G21 1DA" or "G1 1DA", where I only want it to show the G on its own, it's the only post code that has one letter in it, and want to ignore the rest.
Can I do this with a generic formula that would cover both my examples above i.e EH54 5DZ = EH & G1 1DA = G?
Cheers,
D.
Bookmarks