I have a spreadsheet with thousands of cells containing statements. None of them have a full stop. All of them need a full stop. is there a way to do this or do I have to wade through them all?
I have a spreadsheet with thousands of cells containing statements. None of them have a full stop. All of them need a full stop. is there a way to do this or do I have to wade through them all?
A B C 2Now is the time Now is the time. B2: =A2 & "." 3for all good men for all good men. 4to come to the aid to come to the aid. 5of their country of their country.
Then copy and paste the results as values over the original column.
Entia non sunt multiplicanda sine necessitate
If your data is in column A, you can use a formula like this:
=IF(A1="","",A1&".")
Copy that down, fix the values, then you can delete column A.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks