Software

Ask something
Discussion Locked

Excel Find and Replace

0 helpful
5 replies

by sands_anthony

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Here is the contents of the cell.

Cook Islands Trust Limited Tr

how do I do a find and replace of
Tr and replace it with TR.
Here is the tricky part.
I only want the TR by iteslf replaced with TR
not the Tr in Trust to become TRust

5 replies

by dklippert

Excel is not a versatile as Word.

In this case, Find and replace space Tr with space TR (Just hit the space bar to enter a space)

by wondering

I'm sure you've already found an answer to this, but this is what I would do.

Search for Limited Tr
replace with Limited TR

This discussion is closed to new replies.