<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
I need to do 2 things <br />
a) replace existing text entries in a spreadsheet with some new text, how can i do this in one action or formula please?<br />
b) just delete some text from existing item entries within the spreadsheet<br />
<br />
a) Delivery for the bricklayer<br />
All I want to do here is replace the word &quot;delivery&quot; with &quot;cartage&quot; everywhere throughout the spreadsheet<br />
<br />
b) For example here is an existing text entry;<br />
Floor - smart joists - Timber[LF][LF][LF][LF]<br />
*all i want to do here is just delete the text [LF] but there are 4 in here, in other entries <br />
there may only be 2 and others just 1 so how can i get rid of this?<br />
<br />
My approach was to first use the filter on the spreadsheet so it only shows the text im looking for but now i need some formula or help as to how i can make changes a) and b)?
</div>
</div>


Hi Experts,
I need to do 2 things 
a) replace existing text entries in a spreadsheet with some new text, how can i do this in one action or formula please?
b) just delete some text from existing item entries within the spreadsheet

a) Delivery for the bricklayer
All I want to do here is replace the word "delivery" with "cartage" everywhere throughout the spreadsheet

b) For example here is an existing text entry;
Floor - smart joists - Timber[LF][LF][LF][LF]
*all i want to do here is just delete the text [LF] but there are 4 in here, in other entries 
there may only be 2 and others just 1 so how can i get rid of this?

My approach was to first use the filter on the spreadsheet so it only shows the text im looking for but now i need some formula or help as to how i can make changes a) and b)?

Excel 2010-Replace and Substitute Multiple Text Entries in CSV File

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.