Putting a "period" at the end of every cell's-worth of text

  • Thread starter Thread starter OP
  • Start date Start date
O

OP

Hi. I have a large number of cells in a column, each of which
contains text. Some cells of text end in a period, some do not. Is
it possible to write a function that would add a period to the end
of each textbox? I am not worried about corner cases, i.e., where
the text ends with "M.D." or suchlike.

Thanks for any help -
 
Insert an adjacent column. The following example assumes that the text is in
cell A2 and the formula in B2 (The inserted column).

=IF(RIGHT(A2,1)=".",A2,A2&".")

Copy the formula down for the full length of the data then select the column
and then Copy->Paste Special->Values over top of itself.

You can then delete the other column or copy the new data over it and remove
the added column.
 
OssieMac said:
Insert an adjacent column. The following example assumes that the text is in
cell A2 and the formula in B2 (The inserted column).

=IF(RIGHT(A2,1)=".",A2,A2&".")

Copy the formula down for the full length of the data then select the column
and then Copy->Paste Special->Values over top of itself.

You can then delete the other column or copy the new data over it and remove
the added column.
Click to expand...

Sweet, thanks.
 
Hi,

Maybe this, with your data in col. A
Put this in B1 and drag down as far as needed
=IF(RIGHT(A1,1)=".",A1,A1&".")

HTH
Martin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clever formula required to sum contents of cell 6
Number series at end of column macro? 4
Spacing around text 1
How do I add a " at the end of every cell text... 7
Populate cell with multiple non-blank text values 3
Excel Excel - Macro to Insert Cell 0
delete the extra space at the end of an entry 1
Is Auto Expansion (i.e., wrap text) of a cell possible when thecell's contents are based on another 2

Back
Top