B bines53 Active Member Feb 8, 2014 #1 Hello , In cell can appear in four letters, I would like to replace them TO numbers in other cell . If appears A replace to 1 If B appears replace to 2 If C appears replace to 3 If D appears replace to 4 Thank you !
Hello , In cell can appear in four letters, I would like to replace them TO numbers in other cell . If appears A replace to 1 If B appears replace to 2 If C appears replace to 3 If D appears replace to 4 Thank you !
oldchippy Active Member Feb 8, 2014 #2 Hi bines53, If your letters are in column A, then put this in B1 and copy down =CODE(A1)-64
B bines53 Active Member Feb 8, 2014 #3 Hi oldchippy Is it possible to ask for the opposite, namely to replace letters to numbers Thank you !
Hi oldchippy Is it possible to ask for the opposite, namely to replace letters to numbers Thank you !
oldchippy Active Member Feb 8, 2014 #4 Hi, Yes with numbers in column A and this in B1 copied down =CHAR(64+A1)
