I want to remove large amount of texts from the A column. For example, I want the first values to read Value Pack Sticks and the second value to read Crunchy Clams. How can I achieve this in mass quantity?
I added a screen shot below.
IF the pattern is always: 4 space 2 space 4 space WHATyouWANT .pdf
then you could use:
=MID(A1:A1000, 14, LEN(A1:A1000)-17)
Adjust A1:A1000 to the range you need and if you don't want to keep the original you can COPY the result and PASTE VALUES and then delete the original.
Another Alternative is to use the Text To Columns function on the DATA tab. I think it will take 2 "passes". On 1 pass it is fixed column width where you remove the first part of the column:
note how I mark the first column to skip it and not use it.
Then on 2nd use you can delineate the columns using the "." character to strip off the .pdf portion.
Accepted Solutions
IF the pattern is always: 4 space 2 space 4 space WHATyouWANT .pdf
then you could use:
=MID(A1:A1000, 14, LEN(A1:A1000)-17)
Adjust A1:A1000 to the range you need and if you don't want to keep the original you can COPY the result and PASTE VALUES and then delete the original.
Another Alternative is to use the Text To Columns function on the DATA tab. I think it will take 2 "passes". On 1 pass it is fixed column width where you remove the first part of the column:
note how I mark the first column to skip it and not use it.
Then on 2nd use you can delineate the columns using the "." character to strip off the .pdf portion.