Merging cells

[indianamilitary]

How can I merge text data in two cells. Either into one of the original cells, or into a new cell ?

Example:
Cell 1 contains "1,7,CUB(space)"
Cell 2 contains "1958vol3"

I want to end up with "1,7,CUB 1958vol3" (no actual quote marks)

Thanks

 

[suesloan]

Use the Combine() function either as a modification formula on the third field, or define the combination field as a calculated-type field with formula. Something like:

newfield = Combine(Cell1fieldname,' ',Cell2fieldname)

Sue Sloan