If your data is in row 1, you can use this formula in F1:

=A1&B1&C1&D1&E1

Hope this helps,

Hutch

"EngelseBoer" wrote:

hi

I would like to display contents of preceeding cells consecutively
ie - generate a single number from numbers in 5 preceeding cells

How might i be able to do this please

eg.

A B C D E = F
2 24 15 76 99 = 224157699

much obliged for any help