Paste or insert data before and after cel contents

N

New Expressor

Hi

I have an interesting problem...

I have an Excel spreadsheet with hundreds of Hotel locations. Column A has a
Hotel ID in a numeric format.

I can make this into a URL if I can insert/paste a string of text before and
after it.
e.g Hotel ID = 435645 URL would be
http://mydomain.com/blahblah&hotelID=435645&blahblah.com
So (and this is shortened) 'http://mydomain.com/blahblah&hotelID=' goes
before the number and '&blahblah.com' goes after.

How can I get Excel 2007 to do this for me? Is it possible?

Thanks
 
S

Shane Devenshire

Hi,

If the stuff you want before is in cell B1 and the stuff you want after is
in C1 and your core stuff is in A1 then

=B1&A1&C1

combines them. You would then want to convert them to values, probably, to
get rid of the formulas.
 
N

New Expressor

Thanks Shane

Doh - I should have thought of that.

How do I do the 'convert them to values' part?

Thanks
 

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

CompareValues 5
Micros or paste special(link) 1
Re: Cut and "insert cut cells" in Excel 2007 doesn't work. 9
How do you insert " before and after each sentence in every cell? 2
Can I insert 3 blank rows befoe a particular piece of data? 4
Excel 2003 pauses after copy or paste actions 8
How do I insert a row after every row of data in XL? 5
Copy cell contents, then paste into the same cell with other text. 6

Top