Edit text in all the fields in a column(not manually)

[svelma]

Hi All,

I have a column that has thousands of rows with text similar to "duplicate value found: Service Role duplicates value on record with id: a0YT0000003lFG9".

Now I want to edit the column so that I just need the id in each field remaining, which is "a0YT0000003lFG9".

If it was for few records, we can do it manually. But, I have thousands of them. Is there a formula that I can use to do this?

Thanks for your help.

--
Velma

 

[doofusboy]

Is the ID always the last thing in the cell and is it always 15 characters?

 

[svelma]

Yes, it is.
Actually, I found the solution using delimited feature under Data tab - text to columns, by selecting ':' as my delimiter. Because there is a colon before id in all the fields.

Thanks,
Velma.

 

[hippiehacker]

I'm pretty sure there are better solutions but to be quick and if its always the same text use

=MID(Cell;74;15)

 

[svelma]

Thank you.

 

[doofusboy]

If it's always the last 15 characters, the easiest might be:

=RIGHT(A1,15)