"The" to ", The"

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hi,
i have a list and i would like to change a cell to read "Goonies, The"
instead of "The Goonies".
any ideas?
 
James,

Assuming the value to be changed is in A1, use the following
formula

=IF(LEFT(A1,4)="The ",MID(A1,5,LEN(A1))&", The",A1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
-----Original Message-----
Hi,
i have a list and i would like to change a cell to read "Goonies, The"
instead of "The Goonies".
any ideas?
Click to expand...


Ctrl+H
Find What = "The "
Replace What = ", The"
 
no, this wouldn't work for me because i fave a lot of different titles and
i'd have to Ctrl+H for each title.
the actual formula's worked like a charm.
 
Back
Top