How can I get this formula to work

Question

Hi,

I still have a lot to learn in Smartsheet, but I have been using co-pilot to assist. However, I need help with this formula that I cannot get to work. My goal is to strip the site names off any special characters expect for the first four letters# and "offnet. I'll appreciate the any assistance that can be provided to get this to work. Thanks in advance!

=IF(    CONTAINS("ABDC#", "" & [Site Name]@row),    LEFT(        "" & [Site Name]@row,        IFERROR(            MIN(                FIND("F", "" & [Site Name]@row),                FIND(" ", "" & [Site Name]@row),                FIND("-", "" & [Site Name]@row)            ) - 1,            LEN("" & [Site Name]@row)        )    ),    TRIM(SUBSTITUTE("" & [Site Name]@row, "(OFFNET)", "")))

Adeliz · Answer

Hi Paul,

Thanks for your willingness to assist and yes, I did have specific characters I wanted to remove, which was basically anything that was after "ABCD#1234" . I was able to get it to work the way I wanted with this formula "

Hi Gillian, thank you so much for your willingness to help. I was able to get it resolved eventually with this formula with the assistance of co-pilot "

=LEFT([Site Name]@row, FIND("F", [Site Name]@row + "F") - 1)"

I appreciate your prompt response.

Adeliz · Answer

Hi Gillian, thank you so much for your willingness to help. I was able to get it resolved eventually with this formula with the assistance of co-pilot "

=LEFT([Site Name]@row, FIND("F", [Site Name]@row + "F") - 1)"

Paul Newcome · Answer

So you want to keep the first four letters and the site name, and remove any special characters as well as "(OFFNET)"?

Do you have a set list of characters you want removed? It looks like space, hyphen, and the letter "F"?

Do you have some screenshots for context?