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

[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 -

 

[OssieMac]

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.

 

[OP]

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.

Sweet, thanks.

 

[MartinW]

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