Hi there,
The formula I'm using to remove commas, spaces and full stops is working I just can't figure out what to add to it to remove brackets, here's the formula below:
=IF(OR(RIGHT(TRIM(F227),1)={",","."}),LEFT(TRIM(F227),LEN(TRIM(F227))-1),TRIM(F227))
So if I have "(Mrs)," it returns "(Mrs)" and I really don't want the brackets.
Hoping that somebody could help...
Bookmarks