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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

OP - 10 Mar 2008 03:53 GMT

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 -

Reply to this Message

OssieMac - 10 Mar 2008 04:11 GMT

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.

Signature

Regards,

OssieMac

> 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
[quoted text clipped - 3 lines]
>
> Thanks for any help -

Reply to this Message

OP - 10 Mar 2008 04:21 GMT

> Insert an adjacent column. The following example assumes that the text is in
> cell A2 and the formula in B2 (The inserted column).
[quoted text clipped - 6 lines]
> You can then delete the other column or copy the new data over it and remove
> the added column.

Sweet, thanks.

Reply to this Message

MartinW - 10 Mar 2008 04:21 GMT

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

> 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
[quoted text clipped - 3 lines]
>
> Thanks for any help -

Reply to this Message

Rate this thread: