View Single Post
  #1   Report Post  
Lester Mosley
 
Posts: n/a
Default Help with series data

I am trying to create a sheet.. But In A1 i need to to look like this:

TOTE20000
TOTE20000
TOTE20000
TOTE20000
TOTE20001
TOTE20001
TOTE20001
TOTE20001

BUT i need to keep this series up to TOTE24999

Can anyone help me with a simple solution? It wont see the pattern with
TOTE infront but will with just the numbers, But when I do a Replace it
starts chunkign the numbers to decimals.

I appreciate any help!