Thread: [Solved] Using formula to rewrite a phrase in different way ?
View Single Post
 
Old 03-26-2021, 05:18 AM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
Please add workbook examples, it just wastes time recreating data

Try =TRIM("TO "&LEFT(E9,FIND("TO",E9)-1))
Reply With Quote