Hi all, 

I want to Find and replace a column that has a bunch of rows with a text that says 

“Liz A on 09/18/2024: 003TV00000DiIg6YAF”

The problem is the column will have a bunch of variety between the rows- for instance: 

“Liz A on 9/19/2024: 9349943GTH4i98494”

“Liz A on 10/21/2023: 49849q1i9H0390339”

and so on (different number/letter variation and different text around it (the quotation and formatting stays the same but the info is different))

It could even be another user so the user changes. 

I am wanting to delete all information in this column except the number/letter combination. But since the information around the number/letter combination can be different I’m not sure of an easy way to remove all of that text around it. Does anyone know of a way to go about this?

​Hi all,  I want to Find and replace a column that has a bunch of rows with a text that says “Liz A on 09/18/2024: 003TV00000DiIg6YAF” The problem is the column will have a bunch of variety between the rows- for instance: “Liz A on 9/19/2024: 9349943GTH4i98494″”Liz A on 10/21/2023: 49849q1i9H0390339″and so on (different number/letter variation and different text around it (the quotation and formatting stays the same but the info is different))It could even be another user so the user changes.  I am wanting to delete all information in this column except the number/letter combination. But since the information around the number/letter combination can be different I’m not sure of an easy way to remove all of that text around it. Does anyone know of a way to go about this?  Read More

​