Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Help with series data
I have to read between the lines a bit because I'm not really clear on what
you want. Let's say you want to enter 20000 in the cell, but you want it to be displayed as TOTE20000. Enter 20000 and then FORMAT CELLS CUSTOM Enter "TOTE"00000 "Lester Mosley" wrote in message oups.com... 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! |
#3
|
|||
|
|||
Help with series data
Thanks.. I did find another method from a co-worker..
A1 would have the root 20000, a2 would have =A1+.25 then b1 would have ="TOTE"&int(a2) It works.. have it drop off the decimal. copy/paste special. a few extra steps but we got there. Thanks for your help though |
#4
|
|||
|
|||
Help with series data
How about a "one-shot" deal?
Enter this in A1 and copy down: ="TOTE"&20000+INT((ROW()-1)/4) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Lester Mosley" wrote in message ups.com... Thanks.. I did find another method from a co-worker.. A1 would have the root 20000, a2 would have =A1+.25 then b1 would have ="TOTE"&int(a2) It works.. have it drop off the decimal. copy/paste special. a few extra steps but we got there. Thanks for your help though |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
QUESTION- Simpler Way to Add a Data Series to Other Graphs? | Excel Discussion (Misc queries) | |||
HELP- Copy a Data Series to Other Graphs? | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |