M Manesh New Member Apr 13, 2015 #1 Dear Chandoo, I am having some difficulty with a formula and cannot understand why the logic is returning an error. I have uploaded a spreadsheet herewith and would appreciate your assistance with resolving the bug. Thank you. Best regards, MN Attachments Formula.xlsx Formula.xlsx 12.2 KB · Views: 0
Dear Chandoo, I am having some difficulty with a formula and cannot understand why the logic is returning an error. I have uploaded a spreadsheet herewith and would appreciate your assistance with resolving the bug. Thank you. Best regards, MN
N NARAYANK991 Excel Ninja Apr 13, 2015 #2 Hi , The result of the text functions such as MID , LEFT , RIGHT are text , whereas the digits you have in row 1 are numbers. Conversion is required. See the attached file. Narayan Attachments Formula.xlsx Formula.xlsx 12.3 KB · Views: 0
Hi , The result of the text functions such as MID , LEFT , RIGHT are text , whereas the digits you have in row 1 are numbers. Conversion is required. See the attached file. Narayan
M Manesh New Member Apr 13, 2015 #3 NARAYANK991 said: Hi , The result of the text functions such as MID , LEFT , RIGHT are text , whereas the digits you have in row 1 are numbers. Conversion is required. See the attached file. Narayan Click to expand... Thank you Narayan. This works perfectly. Cheers MN
NARAYANK991 said: Hi , The result of the text functions such as MID , LEFT , RIGHT are text , whereas the digits you have in row 1 are numbers. Conversion is required. See the attached file. Narayan Click to expand... Thank you Narayan. This works perfectly. Cheers MN
