Sorting by middle data in column

[wndsfr68]

I'm trying to delete data out of a cell in order to sort. Below is an example of the data in the column. I want to delete "Claims-Claim Attention-" in the entire column so i can then sort by the number. Or, if anyone knows how to sort by data that isn't first in the column. Example, if i just wanted to sort by the number in the column. Thanks

column C

Title

Claims - Claim Attention - 2022c0122132 Review Incoming Image - Req Payment For Medical Payment

Claims - Claim Attention - 2022c0122132 Review Incoming Image - Req Payment Of Medical Payment

Other - Ad Hoc Report [Litigation_Log]

Claims - Claim Attention - 2022c0117385 Review Incoming Image: From: Jeromemiron@Adr.Org <Jeromemiro...

Claims - Claim Attention - 2022c0117385 Review Incoming Image: From: Jeromemiron@Adr.Org <Jeromemiro...

Claims - Claim Attention - 2022c0117385 Review Incoming Image: From: Jeromemiron@Adr.Org <Jeromemiro...

Claims - Claim Attention - 2022c0117385 Review Incoming Image: From: Jeromemiron@Adr.Org <Jeromemiro...

 

[Joe4]

Welcome to the Board!

You should be able to do this pretty easily.
Simply select the whole column and then go to Find/Replace, and Replace the string "Claims-Claim Attention-" with nothing, and it will remove it from all your cells.

 

[wndsfr68]

Appreciate the quick response. Tried as you outlined but received the below message.

 

[Joe4]

Possible issues:

1. You have not selected the correct range to apply this to. Have you selected the entire column you want to apply this to before running these steps.

2. Your values do not match exactly. You could have special characters if the data comes from another application or a download from the web. The easiest thing to do is to go to one of the records you want to replace, highlight/select the text at the beginning that you want to replace, copy just that portion, and then paste it in the "Find what:" box (so you are not manually typing that part, but copy/pasting it right from one of the record).

3. As the warning box says, you could be working with a sheet that has protection on it. Can you manually update any one of these cells? If not because the sheet or range is protected, you have to first remove the protection!