One easy, generic way

Assume your source data in A2:A100
Put in B2: =INDEX(A$2:A$100,ROWS($1:1)*2-1)
Copy down as far as required to exhaust.

The series generator for 1,3,5,7,...
is: ROWS($1:1)*2-1

You could place in any startcell: =ROWS($1:1)*2-1
and copy down to see the series gen

Hence plugging the above into: INDEX(SourceCol,SeriesGenerator)
and copying down will return exactly what you seek

Success? hit the YES below
--
Max
Singapore
---
"Joe Troutman" wrote:
I have a column of data, say 1 to 100. I want to create a new column with
every other data point, i.e. 1,3,5,7,9.......

What is the best way to create that?

Thanks