Auto Fill / Drag Cell

rbahbah

Board Regular
Joined
Oct 23, 2008
Messages
63
Hello,

I have "/TAPE-01.JPG" in cell A1 and I'd like to drag this to the right and have Excel generate /TAPE-02.JPG, /TAPE-03.JPG, /TAPE-04.JPG etc...The only thing that I want to change is the number.

How can this be done?

Thanks!
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

wigi

Well-known Member
Joined
Jul 10, 2006
Messages
7,958
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
  3. Web
Hi there. Consider the formula:

="/TAPE-"&TEXT(ROW(),"00")&".JPG"
 

rbahbah

Board Regular
Joined
Oct 23, 2008
Messages
63
Hmmmm I don't think it worked. I pasted the formula in cell B1 and when I dragged it, it's returning the same value. Any idea?
 

BenMiller

Board RegularThe ONLY cool kid on the block
Joined
Nov 17, 2011
Messages
1,959
Office Version
  1. 365
Platform
  1. Windows
Try ="/Tape-"&RIGHT("00"&column(A1),2)&".JPG"
 
Last edited:

emilG

New Member
Joined
Jul 11, 2012
Messages
11

ADVERTISEMENT

Alternatively, try: ="/TAPE-"&TEXT(COLUMN(),"00")&".JPG"
 

rbahbah

Board Regular
Joined
Oct 23, 2008
Messages
63

ADVERTISEMENT

Perfect! That does it!

Thanks a bunch!
 

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
I think emilG's got it..
The key piece of information was that you are dragging the formula RIGHT.
Other solutions were based on dragging formula DOWN.
 

wigi

Well-known Member
Joined
Jul 10, 2006
Messages
7,958
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
  3. Web
Sorry, you wanted to drag to the right instead of down.
Then change ROW into COLUMN in my suggestion.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,914
Messages
5,598,840
Members
414,261
Latest member
KatieBsc

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top