Search results

Really apologise on the error in the question itself.. I'm working on couple of codes and hence the confusion in writing the codes and their value. 》If M=1, Y=2, S=3, O=4, R=5, E=6, B=7, A=8, N=9 & K=0 Then, Actual result would be as follows : 》In cell E2 if i enter "SRK", in cell F2 i should...

That's where the catch is... Each product has a different code and everytime a new product is added. Sometimes the same product with different code Eg: Ladies Jeans - PRN - 350 Ladies Jeans - PAR - 395

Thanks.. Salim.. Can't we do it without using vba.. just excel formula

Thanks for your reply.. Deepak Textjoin is for collating texts from different cells. But i have assigned each text for values 0 to 9 as below... 0 = K 1 = M 2 = Y 3 = S 4 = O 5 = R 6 = E 7 = B 8 = A 9 = N Now, if my product cost is 350, i need to enter in coded letters, like PRN (means 350) For...

I have coded each product with a single letter or two or three.. for which if i need to enter a product code "PRN" then the coded value for the same should be 350. If the values assigned is as follows :If M=1, Y=2, S=3, O=4, R=5, E=6, B=7, A=8, N=9 & K=0 You can check the sample file attached.

Hi.. I need help in excel data entry. I have a sheet in which under product code column, i need to enter letters as a part of code for my products and the assigned value to appear in the next cell. Example: If M=1, Y=2, S=3, O=4, R=5, E=6, B=7, A=8, N=9 & K=0 In cell E2 if i enter "PRN", in...