Row #s Not Advancing When I Copy Formula

[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))

 

[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

 

[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

 

[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