| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filling a series into a non-empty column
Is it possible to take a series, such as the Item Number example below, and
then filling it into a column that already has text in it? What I want for it do is input each item into the Image column, where it will result in "products/1.jpg, products/2.jpg. products/3.jpg, etc." Item Number 1 2 3 4 5 Image products/.jpg products/.jpg products/.jpg products/.jpg products/.jpg Thank you in advance for your help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Filling a series into a non-empty column
I would do it this way.
Numbers in column A In B1 enter ="products/" & A1 & ".jpg" Double-click on the fill handle of B1 to copy down. Gord Dibben MS Excel MVP On Sat, 18 Aug 2007 09:00:03 -0700, Kathleen wrote: Is it possible to take a series, such as the Item Number example below, and then filling it into a column that already has text in it? What I want for it do is input each item into the Image column, where it will result in "products/1.jpg, products/2.jpg. products/3.jpg, etc." Item Number 1 2 3 4 5 Image products/.jpg products/.jpg products/.jpg products/.jpg products/.jpg Thank you in advance for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help on filling empty cells with string + row() | Excel Discussion (Misc queries) | |||
| Filling empty cells with a value | Excel Discussion (Misc queries) | |||
| Filling a series | Excel Discussion (Misc queries) | |||
| Filling in empty cells in columns | Excel Discussion (Misc queries) | |||
| filling a series | Excel Discussion (Misc queries) | |||
Linear Mode
