Hi Chris,

You could maybe label each statement like aaa, bbb, ccc etc.
Then set the auto correct, replace text as you type options like

aaa        The quick brown
bbb        fox jumps over
ccc         the lazy dog

then aaa bbb ccc in a cell would return
The quick brown fox jumps over the lazy dog

I'm not sure but I think each replace box
should take up to 255 characters.

HTH
Martin

Chris

Can your users follow instructions and click on cells in the order they wish?

They can run this macro and select the cells in the order which gives them a
sentence, but not necessarily grammatically correct.

Sub ConCat_Cells()
Dim x As Range
Dim y As Range
Dim z As Range
Dim w As String
Dim sbuf As String
   On Error GoTo endit
   w = " "
   Set z = Application.InputBox("Select Destination Cell", _
           "Destination Cell", , , , , , 8)
   Application.SendKeys "+{F8}"
   Set x = Application.InputBox("Select Cells, Contiguous or Non-Contiguous", _
           "Cells Selection", , , , , , 8)
   For Each y In x
   If Len(y.Text) > 0 Then sbuf = sbuf & y.Text & w
   Next
   z = Left(sbuf, Len(sbuf) - Len(w))
   Exit Sub
endit:
   MsgBox "Nothing Selected.  Please try again."
End Sub

Gord Dibben  MS Excel MVP