Thread: Turn vertical data to horizontal data automaticaly
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dmb490 dmb490 is offline
external usenet poster
  
Posts: 1
Default Turn vertical data to horizontal data automaticaly

in a new cell use the concatenate function to simply string the data
together
=Concatenate(NameCell, AddressCell, CityStateZipCell)


--
dmb490
------------------------------------------------------------------------
dmb490's Profile: http://www.excelforum.com/member.php...o&userid=36556
View this thread: http://www.excelforum.com/showthread...hreadid=563062

Reply With QuoteReply With Quote