J Jennifer Burnel Nov 3, 2003 #1 how would I merge multilple data values: in seperate columns as: js-1234 to .jpg Thanks
M Martin Nov 3, 2003 #3 Hi Jennifer, Try using =(A1&B1) where A1 and B1 are the cells where your data sits
M Melanie Caughey Nov 3, 2003 #4 X-No-Archive: yes Jennifer Burnel said: how would I merge multilple data values: in seperate columns as: js-1234 to .jpg Thanks Click to expand... One way to combine fields in Excel is If worksheet B2 contains js-1234 and C2 contains .jpg then the formula =CONCATENATE(B2,C2) in D2 returns the entry js-1234.jpg
X-No-Archive: yes Jennifer Burnel said: how would I merge multilple data values: in seperate columns as: js-1234 to .jpg Thanks Click to expand... One way to combine fields in Excel is If worksheet B2 contains js-1234 and C2 contains .jpg then the formula =CONCATENATE(B2,C2) in D2 returns the entry js-1234.jpg