| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste or insert data before and after cel contents
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...5&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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste or insert data before and after cel contents
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. -- If this helps, please click the Yes button Cheers, Shane Devenshire "New Expressor" wrote: 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...5&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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste or insert data before and after cel contents
Thanks Shane Doh - I should have thought of that. How do I do the 'convert them to values' part? Thanks "Shane Devenshire" wrote: 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. -- If this helps, please click the Yes button Cheers, Shane Devenshire "New Expressor" wrote: 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...5&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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste or insert data before and after cel contents
If your 435645 is in cell A2, use the formula
="http://mydomain.com/blahblah&hotelID="&A2&"&blahblah.com" -- David Biddulph "New Expressor" wrote in message ... 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...5&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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste or insert data before and after cel contents
Copy, then Edit/ Paste Special/ Values
-- David Biddulph New Expressor wrote: Thanks Shane Doh - I should have thought of that. How do I do the 'convert them to values' part? Thanks "Shane Devenshire" wrote: 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. -- If this helps, please click the Yes button Cheers, Shane Devenshire "New Expressor" wrote: 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...5&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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What does InsertNameLabel & InsertNamePaste do? | Excel Discussion (Misc queries) | |||
| How can I insert the contents of a folder into Excel | Excel Discussion (Misc queries) | |||
| How to insert the contents of two cells in a footer? | Excel Discussion (Misc queries) | |||
| paste contents from other spreadsheet | Excel Worksheet Functions | |||
| Insert new row as cell contents change | Excel Discussion (Misc queries) | |||
Linear Mode
