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

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

"Patti Robertson" <Patti wrote in message
...
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))

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
wrote:

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