Adding periods to sentences.
In an empty cell, say B1, next to, for example, A1, where your sentence is,
you could enter =A1 & "."
Then you could copy the contents of B1 and Paste Special Data back into
cell A1.
To do a range of cells, simply copy the formula down the column. Delete the
formula column when you're satisfied your sentences are how you want them.
Backup your spreadsheet before doing this of course...
"RJJ" wrote:
How do I add periods to the ends of sentences in multiple cells at once?
|