Hi
I am using the following formula to remove a ";" from last character of a string if it exists
=IF(RIGHT(A1,1)=";",LEFT(A1,LEN(A1)-1),A1)
What I am struggling with is trying to nest this so that if the data had 2 semi colons it would also delete these
For example the data I have is as follows
EXAMPLE1;EXAMPLE1;EXAMPLE1
EXAMPLE2;EXAMPLE2;
EXAMPLE3;;
Is there a formula to remove the semi colons, at the end only and not to remove any other characters? Any help would be much appreciated!
Many Thanks
Jermaine
I am using the following formula to remove a ";" from last character of a string if it exists
=IF(RIGHT(A1,1)=";",LEFT(A1,LEN(A1)-1),A1)
What I am struggling with is trying to nest this so that if the data had 2 semi colons it would also delete these
For example the data I have is as follows
EXAMPLE1;EXAMPLE1;EXAMPLE1
EXAMPLE2;EXAMPLE2;
EXAMPLE3;;
Is there a formula to remove the semi colons, at the end only and not to remove any other characters? Any help would be much appreciated!
Many Thanks
Jermaine