Thread: Concatenate
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
SamuelT SamuelT is offline
external usenet poster
 
Posts: 1
Default Concatenate


Hi,

If your text is in A1 and B1. Enter the following in the cell that you
are concatenating:

=A1 & " - " & B1

HTH,

SamuelT


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=560176