Formula Help

[How_Do_I]

Hello, I'm interested in the last digit of the string... If it's a "." or a ";" I need that removing, if it's not a "." or a ";" then I want one cell to the left... So, what formula would I place in C2 so that all my returns are "Assistance to Finland" please...

Sheet3

	B	C

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:191px;"><col style="width:184px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="bgcolor: #ffff00"]Assistance to Finland[/TD]
[TD="bgcolor: #ffff00"]Assistance to Finland[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]
[TD="bgcolor: #ffff00"]Assistance to Finland.[/TD]
[TD="bgcolor: #ffff00"]Assistance to Finland[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]
[TD="bgcolor: #ffff00"]Assistance to Finland;[/TD]
[TD="bgcolor: #ffff00"]Assistance to Finland[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie HTML 4


<strike></strike>

 

[jtakw]

Hi,

If the "." or ";" is Always at the end of the Text string, use C2 formula.
If there might be Other "." or ";" within the text string that you Don't want removed, but remove the End one, use D5 formula:

Book1
	B	C	D
2	Assistance to Finland	Assistance to Finland
3	Assistance to Finland.	Assistance to Finland
4	Assistance to Finland;	Assistance to Finland
5	Assistance. To; Finland		Assistance. To; Finland
6	Assistance; to. Finland;		Assistance; to. Finland
Sheet579

Cell Formulas
Range	Formula
C2	=SUBSTITUTE(SUBSTITUTE(B2,".",""),";","")
D5	=IF(OR(RIGHT(B5)={".",";"}),LEFT(B5,LEN(B5)-1),B5)

 

[How_Do_I]

Thanks again jtakw… You've contributed so much to what I'm trying to do...!

 

[jtakw]

You're welcome, glad to help, and thanks for the feedback.