#1
|
|||
|
|||
Using formula to rewrite a phrase in different way ?
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 |
#2
|
|||
|
|||
Please add workbook examples, it just wastes time recreating data
Try =TRIM("TO "&LEFT(E9,FIND("TO",E9)-1)) |
#3
|
|||
|
|||
Into E9, enter the formula
Code:
=IF(ISODD(ROW()),"S.P.C. BAR TO","IPC Connection TO") 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 Code:
=IF((ROW()-9)/7=INT((ROW()-9)/7),"S.P.C. BAR TO",IF((ROW()-10)/7=INT((ROW()-10)/7),"IPC Connection TO","")) |
#4
|
|||
|
|||
Thx Purfleet and ArviLaanemets
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Determine if a Phrase is on a Line by Itself | scienceguy | Word VBA | 2 | 06-06-2020 04:58 AM |
Insert <tab> in a phrase with condition | kjxavier | Word | 1 | 08-01-2014 08:57 PM |
code to rewrite numbers | romanticbiro | Word VBA | 7 | 02-15-2014 03:04 PM |
Exclude phrase from email | kiwiora | Outlook | 2 | 07-16-2012 03:03 PM |
How to find exact phrase | CabbageTree | Outlook | 2 | 05-14-2012 11:24 AM |