Word Group Deletion

  • Thread starter Thread starter zerconian
  • Start date Start date
Z

zerconian

I have a large column of titles that I would like to delete all th
"The's"
in the beginning of the titles.
If anyone could help me on this it would be much appreciated. I am
novice Excel user
 
Hi
try the menu 'Edit - Replace'
- enter your text to replace
- in the second entry field enter nothing
 
Can you use a helper column with a formula like:

=IF(LEFT(A1,4)<>"the ",A1,RIGHT(A1,LEN(A1)-4))

And drag it down.

(I actually looked for "The ". Thelma and Louise wouldn't be changed.
 
Back
Top