removing the end full stop from a paragraph of text within an excel cell

[sliderxb]

Ideal for laser copying in a choice of popular colours.Clear wrapped in reams for ease of colour identification.Pastel assorted packs contain 100 sheets each of Cream, Green, Blue, Pink and Yellow paper.Bright assorted packs contain 100 sheets each of Yellow, Orange, Red, Deep Green and Blue.A4 80gsm.


Using the text as above copy into a cell in excel. i want to remove the very end fullstop from a paragraph of text. has anyone got a formula for this


any ideas

 

[Hui]

Assuming your cell is A1

=left(A1,len(A1)-1)

 

[sliderxb]

great stuff. works a treat thanks for the help.

 

[pradhishnair]

hello Hui.. hope you doin fine..


please guide me thru this..

the above formula will delete a last character of the cell. is it possible to identify if the cell actually contains a full-stop and then delete the full stop only.

 

[NARAYANK991]

Hi Pradish ,


Check if the last character of the cell is a "." , using the RIGHT function ; =RIGHT(A1,1) will return the last character of cell A1. =IF(RIGHT(A1,1)=".",Hui's formula,A1) will delete the "." if it is present , else it will copy the cell as it is.


=IF(RIGHT(A1,1)=".",LEFT(A1,LEN(A1)-1),A1)


is the full formula.


Narayan