concatenate or 'Replace'

K

KHashmi316

I'm trying to append (concatenate) the values in an entire column o
data (full of SKUs, which are numbers merchants use to identify indiv
products) with a URL.

Selecting all of the column and then using the Replace utility an
various wildcards, didn't help.

Ditto bad luck with using a few concatenate formulas (such as i
Excel's help files).

Again I want to append (concatenate) a column of cells containing sk
with a sinle url. E.g.

Single URL:

http://www.somesite.com?s=[SKU]

SKU

12345
67890
98765
43210
etc. (over 2000 cells)

Thx in advance for any info you may shed!
-KH
LA, Calif
 
J

JulieD

Hi

i would do it like this
in a column (adjacent to or near your SKUs) i would enter
="http://www.somesite.com?s="&A6 (where the first SKU is in row 6)
then i would copy this down the list (double click on autofill handle will
do it for you)
then i would use copy & paste special - values to change this column into a
value rather than a formula

Hope this helps
Cheers
JulieD
 
L

Llobid

I believe you can easily do this by creating an empty column beside th
column with your numbers, then putting the following formula an
copying down. This formula assumes that the data you are using is in A
and the concatenation formula will go into B1.

=CONCATENATE("http://www.yoururl.com",A1)

If you are supposed to have a period before your number, then...

=CONCATENATE("http://www.youurl.com,".",A1
 
K

KHashmi316

Thank you for *all* your *useful* tips. I tried bj's first and i
worked like a charm:

"if all of the cells contain numbers only, you can select the colum
and use <format><cells><Custom> "

It even filtered down nicely to *.csv , which is how I will ultimatel
use the data -- any other WebMerge users out there? ;)

Best,
-KH
LA, Californi
 
Top