Well it looks like the LEFT command cant be used for a range of cells. But
what I need to do is basically capture the first three charters in the cells
(numbers) and ignore the last three (text). And use only the numbers for the
data range in the chart.

"Luke M" wrote:

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?


.