Replies

Go to a blank sheet and use the “UPPER” formula in cell A1 -linking it to cell A1 on the sheet you want to convert. Autofill the entire workbook – and you will have a copy in upper case…but you’re not finished yet. Copy and paste this sheet using paste special > value only > to another sheet – this will eliminate the cells being a formula and give you text only.