Deleting/Replacing Part of a String With 3 Static Characters and 4 Variable Characters

[reberryjr]

I have thousands of records that have User IDs in them. I need to find a way to delete these User IDs, as the data is being sent externally. The issues that I'm encountering are:
- The text is not static. It always starts with UID, but the last 4 characters can be alpha-numeric variables.
- The text can be found in any position of a cell.
- I will only have a 4 hour window to pull data from various locations, consolidate and format it.

I've looked through this site, and a couple of other places, but have been unable to find a solution. This looked promising from Google, but I can't seem to get it to fit my needs:

=REPLACE(M14,SEARCH("UID",M14)+7,0,"")

Any assistance is appreciated!

 

[FormR]

Hi,

Here is an option you can try:

Excel 2013/2016
	A	B
1	text UIDA123 ddfas	text ddfas
2	bla bla bla UID1234 text text	bla bla bla text text
Sheet1

Cell Formulas
Range	Formula
B1	=TRIM(REPLACE(A1,SEARCH("UID",A1),7,""))

If this doesn't help, representative examples of your text values and corresponding expected results would be very helpful.

 

[reberryjr]

@FormR Thank you! Works like a charm!

 

[DanteAmor]

Other option:

=SUBSTITUTE(A1,MID(A1,SEARCH("UID",A1),8),"")