| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I fill a series in Nonadjacent cells eg Text 1, Text 2
The text data is located in a single column. I don't mind entering a formula
in each of the 160 nonadjacent cells, I just need to be able to change the starting numerical portion of the first cell and have that change all the following numerical portions of each cell entry. "RagDyeR" wrote: Where is the text data located? Is it in a single column ... single row ... multiple locations? -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "Juikijui" wrote in message oups.com... It would look something like this: a1=Text 1 d1=Text 2 a2=Text 3 d2=Text 4 a12=Text 5 d12=Text 6 a13=Text 7 d14=Text 8 etc... to Text 160 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to fill cells with a different kind of series? | Excel Worksheet Functions | |||
| Sum multiple cells with different numbers and text. | Excel Discussion (Misc queries) | |||
| How do I fill (copy) nonadjacent cells to adjacent cells? | Excel Discussion (Misc queries) | |||
| Linked cells and text boxes | Excel Discussion (Misc queries) | |||
| fill series grayed out (not available, disactivated) | Excel Discussion (Misc queries) | |||
Threaded Mode
