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
 
Back
Top