Solved

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

Posted on 2013-06-06
1
208 Views
Last Modified: 2013-06-16
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)?
0
Comment
Question by:FrankSasso
1 Comment
 
LVL 35

Accepted Solution

by:
[ fanpages ] earned 300 total points
ID: 39228191
Hi,

Do you want a Visual Basic for Applications-coded approach, or are you happy with manual steps to reach your goal?

Manual steps:

a)...

Use the [CTRL]+[H] key combination (or the "Edit" menu followed by the "Replace..." menu item).

Click the [Options >>>] button.

Set "Within:" to read "Workbook".
Set "Find what:" to delivery.
Set "Replace with:" to cartage.

Click the [Replace all] button.

b)...

Use the [CTRL]+[H] key combination (or the "Edit" menu followed by the "Replace..." menu item).

Click the [Options >>>] button.

Set "Within:" to read "Workbook".
Clear the "Find what:" field.  Hold down the [ALT] key & then enter [0][0][1][0] on the numeric keypad.  You will not see anything on the screen.
Leave "Replace with:" blank (or clear the existing value from the last replacement).

Click the [Replace all] button.

BFN,

fp.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now