Hi.
Here's a tough one for you to figure out and for me to explain it.
I need to search a column for a particular character and delete only that character. Then, I need to sort the whole worksheet and add the deleted string back into the cell.
Example:
The column contains:
R 12345
R 34567
23456
R 23456
45678
11111

I want to remove the R and then sort the column.
After sorting, put the R back in so it would look like this:
11111
R 12345
23456
R 23456
R 34567
45678

The column contains many different text, including RGY, JR, so focusing on the R didn't work for me. Currently, I remove the R from the string and put it in another column. Then I sort and afterwards put the R back in the string. I'd like to automate that.
Hope I explained that properly. I have to do this with other strings where the R is not at the beginning, though there is always a space after it, for example, [GN] R 12345.
Thanks for your help.