General discussion

Locked

Excel Find and Replace

By sands_anthony ·
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

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel Find and Replace

by DKlippert In reply to Excel Find and Replace

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)

Collapse -

Excel Find and Replace

by sands_anthony In reply to Excel Find and Replace

The question was auto-closed by TechRepublic

Collapse -

Excel Find and Replace

by wondering In reply to Excel Find and Replace

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

Collapse -

Excel Find and Replace

by sands_anthony In reply to Excel Find and Replace

The question was auto-closed by TechRepublic

Collapse -

Excel Find and Replace

by sands_anthony In reply to Excel Find and Replace

This question was auto closed due to inactivity

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums