alpha character reference
alpha character reference
(OP)
I have been beating my head and cannot seem to figure it out, hopefully someone with more smarts than I can help me.
if I have a cell that contains characters,
e.g. Cell A10 contains OA/01 and now I am in Cell D4, I want to have this cell note that the second character (in this case "A")is Alpha and therefore, place a N in Cell D4.
IS THIS POSSIBLE? OR am I asking to much from Excel?
Thanks for any input or suggestions.
if I have a cell that contains characters,
e.g. Cell A10 contains OA/01 and now I am in Cell D4, I want to have this cell note that the second character (in this case "A")is Alpha and therefore, place a N in Cell D4.
IS THIS POSSIBLE? OR am I asking to much from Excel?
Thanks for any input or suggestions.
RE: alpha character reference
Look up the worksheet text functions
btw.. There is a spreadsheet forum on this site
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: alpha character reference
RE: alpha character reference
RE: alpha character reference
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: alpha character reference