Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
marc1972
 
Posts: n/a
Default simple but can't seem to do -help please


Hi,

I am pretty sure I am doing something basic here but can;'t seem to get
it to work


I am setting up a spreadsheet with a list of links

<p This is a really great <a
href=" http://www.anyblog.com/ " blog </a that is well worth a look,
let me know what you think when you get a chance. </p


with a different cell used for each pice of html code but as you can
see when I try to copy and past I keep getting spaces between the cells
which are not in the spreadsheet.

I need to then paste this into a html document but the spaces are
messing with the html.


any help appreciated.

cheers
Marc


--
marc1972
------------------------------------------------------------------------
marc1972's Profile: http://www.excelforum.com/member.php...o&userid=29208
View this thread: http://www.excelforum.com/showthread...hreadid=489377

  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default simple but can't seem to do -help please

Maybe take a look at the CONCATENATION feature...........like

=A1&B1&C1&D1&E1

Vaya con Dios,
Chuck, CABGx3





"marc1972" wrote:


Hi,

I am pretty sure I am doing something basic here but can;'t seem to get
it to work


I am setting up a spreadsheet with a list of links

<p This is a really great <a
href=" http://www.anyblog.com/ " blog </a that is well worth a look,
let me know what you think when you get a chance. </p


with a different cell used for each pice of html code but as you can
see when I try to copy and past I keep getting spaces between the cells
which are not in the spreadsheet.

I need to then paste this into a html document but the spaces are
messing with the html.


any help appreciated.

cheers
Marc


--
marc1972
------------------------------------------------------------------------
marc1972's Profile: http://www.excelforum.com/member.php...o&userid=29208
View this thread: http://www.excelforum.com/showthread...hreadid=489377


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple Formula (I thought) csandi Excel Worksheet Functions 3 November 14th 05 08:47 PM
Looking to create a simple user form with lookup Tim Excel Discussion (Misc queries) 5 November 14th 05 04:57 PM
Simple Simple Excel usage question BookerW Excel Discussion (Misc queries) 1 June 23rd 05 10:06 PM
Help with what should be a simple formula B Millar via OfficeKB.com Excel Worksheet Functions 2 June 16th 05 04:18 PM
Simple But Stumped Brian Keanie Excel Discussion (Misc queries) 3 February 5th 05 02:56 AM


All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"