Hi folk


Cell E9 has this phrase : 'S.P.C BAR TO'
E10 has this phrase : 'IPC Connection TO'



Using Excel formula How can i rewrite below phrase :


Cell E16 :'TO S.P.C BAR'
Cell E17: 'TO IPC Connection'


Thx

Please add workbook examples, it just wastes time recreating data

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

Attached Files

Usning formual to rewite a phrase in different way_Ar12.xlsx (9.1 KB, 8 views)

Into E9, enter the formula
and copy down as much as you need.

This assumes those texts are repeated for every row in copied range.
In case you need fields in intermediate rows empty (i.e. the pair of rows is repeated after 7 next rows), The formula will be like

Thx Purfleet and ArviLaanemets