Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
building YTD figures by adding to a previous months total | Excel Discussion (Misc queries) | |||
adding days | Excel Discussion (Misc queries) | |||
calculating number of three month periods between two dates... | Excel Discussion (Misc queries) | |||
working out quarters (three-month periods) between two dates | Excel Worksheet Functions | |||
adding vertical bars to an embedded chart using VBA | Excel Discussion (Misc queries) |