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

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
Sun Mar 09 22:11:00 CDT 2008

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.

--
Regards,

OssieMac


"OP" wrote:

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

OP
Sun Mar 09 22:21:01 CDT 2008

OssieMac wrote:
> 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
Sun Mar 09 22:21:10 CDT 2008

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

"OP" <facetious_nickname@hotmail.com> wrote in message
news:He6dnTZcA-NYP0nanZ2dnUVZ_hKdnZ2d@speakeasy.net...
> 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 -