Note that your formula is incorrect in what you think it does, the LEFT
function cannot reference a range of cells.

To reference the first 3 cells in a row:
=OFFSET(A1,,,,3)

To reference cells C1:E1 would be:
=OFFSET(A1,,2,,3)

--
Best Regards,

Luke M
"Dave" wrote in message
...
I have a spreadsheet that has a row that I want to use as a data range in a
chart. The cells in the row contain three numbers on the left and three
letters on the right. I can select just the three numbers by using
"LEFT(A1:Z1,3)". How do I use that formula to select just the three
numbers
for the data range in the chart?