Hi,
Does anyone know if there is a function that will just select the alphabetic characters from a cell? I want to use it to get alphabetic part of a postcode, so for example CM19 would become CM, E13 would become E etcetc....I'm using Excel 2002.
Thanks!
Does anyone know if there is a function that will just select the alphabetic characters from a cell? I want to use it to get alphabetic part of a postcode, so for example CM19 would become CM, E13 would become E etcetc....I'm using Excel 2002.
Thanks!