Can't copy single array formula

[tpblazo]

I have created the following formula to produce a hex checksum for a cell of text.

{=DEC2HEX(SUM(CODE(MID(A9,ROW(A1:OFFSET(A1,LEN(A9)-1,0)),1))),5)}

I want to use the checksum to make sure the text hasn't been changed. The problem is I can't copy this formula because it's a dynamic array. I have included a spreadsheet of some sample data and how I'm using the formula. Does anyone have solution that will give the same result and allow me to copy it?

[mewingkitty]

I'm not sure what you mean by "I can't copy it".

Also confused because the formula you posted is not the same as the one in your workbook.

Please Login or Register  to view this content.

LEN(250)-1

That's 2.

Why not just put a 2 in there?

mew?

[arthurbr]

I have created the following formula to produce a hex checksum for a cell of text.

{=DEC2HEX(SUM(CODE(MID(A9,ROW(A1:OFFSET(A1,LEN(A9)-1,0)),1))),5)}

I want to use the checksum to make sure the text hasn't been changed. The problem is I can't copy this formula because it's a dynamic array. I have included a spreadsheet of some sample data and how I'm using the formula. Does anyone have solution that will give the same result and allow me to copy it?

To enter an array formula,paste the formula in the formula bar.
Place your cursor in this bar and press Ctrl+Shift+Enter