Excel 2010-Replace and Substitute Multiple Text Entries in CSV File
Posted on 2013-06-06
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)?