View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bobby Atkinson Bobby Atkinson is offline
external usenet poster
 
Posts: 3
Default Calculate (Auto Fill) cells with numbers and text.

I have a worksheet that I want to use text and numbers in the same cell, and
have
the column auto fill down when I enter the first number & text in the first
cell.
example.
cell A1 I would enter 28XL0001
Cell A2 should auto fill in 28XL0002
Cell A3 should auto fill in 28XL0003.

How can I get excel to do this?