Row #s Not Advancing When I Copy Formula

P

Patti Robertson

Hi All. I'm working on a spreadsheet of addresses that I have to convert to
barcode. I found a plug-in that makes barcode a font. My address parts are
in multiple columns. When I copy the formula to pull the address parts into
one column, the row numbers are not advancing as I copy them down. Here's my
formula. Can anyone tell me what I'm doing wrong?

(=ConvertStringToCode128(Concatenate(G6, H6, I6, J6))
 
J

John

Hi Patti
I don't know anything about your formula
(=ConvertStringToCode128(Concatenate(G6, H6, I6, J6)) but if you concatenate
first like this =Concatenate(G6, H6, I6, J6) the row number will advance as you
copy down, maybe then you can use your formula with the new column
(=ConvertStringToCode128(L6)), something like that..
HTH
John
 
S

stanleydgromjr

Patti Robertson,

Remove the leading *(* from your posted formula.


Try in cell K6:
=ConvertStringToCode128(CONCATENATE(G6, H6, I6, J6))

Then copy K6 down.


Have a great day,
Stan
 
G

Gord Dibben

Make sure calculation mode is set to "automatic"


Gord Dibben MS Excel MVP

On Mon, 26 Oct 2009 10:33:01 -0700, Patti Robertson <Patti
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top