merge multilple data values

  • Thread starter Jennifer Burnel
  • Start date
J

Jennifer Burnel

how would I merge multilple data values:

in seperate columns as: js-1234 to .jpg

Thanks
 
M

Martin

Hi Jennifer,

Try using =(A1&B1) where A1 and B1 are the cells where your data
sits
 
M

Melanie Caughey

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
 

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

Similar Threads

Merging from an Excel file with graphics 1
Width of document changes when merging 1
cursor selecting cells locked on... 3
Mail Merge Directory Conditional Page Break 0
data lookup 0
Mail Merge - displaying a conditional number of decimals 5
Page numbering with Merged Document and IF statements 1
Booklet in Word, Merge Directory from Excel 0

Top