Excel 2010 :: Find And Replace Within Specific Column?

Oct 1, 2012

I have an excel workbook where some sheets have a column called "Name" in Row 3. The column where "Name" appears shifts based upon other criteria so it's not set within 1 specific column.

The real data for the "Name" column starts in Row 5. Is it possible to create a macro that looks in Row 3 for "Name", then once it finds that column, it does a find and replace from Row 5 to the end of the data and replaces every space with a ^.

For example, if I have:

Row 3 Name
Row 4
Row 5 John Smith
Row 6 Jane Doe
Row 7 John Doe
Row 8 Jane Smith

I'd like the data to become:

Row 3 Name
Row 4
Row 5 John^Smith
Row 6 Jane^Doe
Row 7 John^Doe
Row 8 Jane^Smith

I'm using Excel 2010 if that impacts anything.

View 1 Replies


ADVERTISEMENT

Excel 2010 :: Find And Replace Dialog Box

Feb 15, 2012

I have Excel 2010, and a dual monitor setup, with the left monitor being the main one. I have my spreadsheets on the right monitor.

When I open a Find and Replace, the dialog box always goes to monitor #1 (left); I want it on monitor #2.

Is there a way to default it to the "right" monitor?

View 3 Replies View Related

Excel 2010 :: Macro To Perform Find And Replace Function

Apr 8, 2014

I have two sheets. One is named sheet1 where all my data is and sheet2 where all my values are. I want to do a find a replace on column N (sheet1) using the data in sheet2. Column A on Sheet2 has all the values that are found in column N and column B on Sheet2 has what the data should change to.

So for example:

Sheet1 says the following on column N:
cat
dog
lion
bear

Sheet2 says:
Column A
A1: Cat
A2: Dog
A3: Bear

Column B
B1: 2
B2: 8
B3:15

I want the values on column N to be replaced with 2, 8, 15 and so forth. I use excel 2010.

View 1 Replies View Related

Excel 2010 :: Find Duplicates Within Specific Timeframe?

Jun 26, 2014

Is there a way to differentiate the number of unique and duplicate entries (considering multiple criterias) using a formula.

I am finding it hard to describe the request hence i have attached a spreadsheet for reference.

The first tab contains the data where I want the result in 'column J'
The second tab contains the metrics of how to calculate the result.

I am sure this will be difficult to understand at first hence feel free to ask as many questions you would like to [only related to the subject ]

For the record, I use Excel 2007 & 2010.

View 3 Replies View Related

Excel 2010 :: Sum Based On Criteria In Specific Column?

Oct 20, 2011

how can i sum base on the Criteria in Columns G, in this sample the sum should be 67.

Sheet1ABCDEFG1V. GoodGoodFairBadN/AReported29853N/A8Bad31085328N/A410953N/A8Good510853N/A8Good61085378Good77853N/A8V. Good810853N/A8Good910753N/A8Reported108853N/A8Good11585308N/A1210653N/A8Good1367Excel 2010Worksheet FormulasCellFormulaG13=67

View 9 Replies View Related

Excel 2010 :: Row Height And Column Width For Specific Range?

Jul 6, 2013

I have tried and been searching but cannot find the answer. Is it possible to change the row height and column width for only a selected range in my spread sheet, for example, F13:I23? I am using Excel 2010.

View 2 Replies View Related

Excel 2010 :: Display Column If Single Cell Has Specific Value

Nov 27, 2012

I'm using Excel 2010 and I'm having troubles displaying hiding my column B if none of the cells of column A contains either "(Quasi Echec)" or "(Quasi Russite)" at least once.

PHP Code: [URL] ......

Below are my 3 attempts.

Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim c As Range
If Target.Column 1 Then Exit Sub
Application.EnableEvents = False
On Error Resume Next

[Code] ..........

Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Sub GetUniquesInColA()
Dim rng As Range
Dim c
If Target.Column 1 Then Exit Sub
On Error Resume Next

[Code] .........

Code:
Option ExplicitPrivate Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim x As Long
Dim LastRow As Long
LastRow = Range("A65536").End(xlUp).Row

[Code] ...........

View 2 Replies View Related

Excel 2010 :: How To Find First And Last Row And Last Column

May 5, 2012


I'm looking for one function for each of these properties that will provide them with negligible overhead in all or almost all spreadsheet data cases, such as the normal spreadsheets, autofiltered data, large workbooks, etc.

By the way, by "first row", I mean the first row after the header row, given that the header row is in row 1.

View 7 Replies View Related

Excel 2003 :: Find And Replace Missing The Ability To Replace Values?

Feb 5, 2009

This problem has come up fairly frequently lately, and I'm not sure how to fix it, or if this is by design...but in Excel 2003 I can't seem to do a "Find and Replace" based on the value of a cell. I can do a find, based on cell value, but the moment I change to the replace tab, the "values" and "comments" are missing from the "look in" dropdown.

I've only noticed this when I'm trying to replace on a filtered list, so I'm not sure if that is part of the issue.

Perhaps an alternative way of arriving at the same goal. Basically I have a worksheet with a number of filtered columns. They are filtered just right, using custom filtering, and so I do not want to undo the filters. In some columns I have formulas that are returning #VALUE! errors. I'd like to replace all of these cells with NA.

View 6 Replies View Related

Excel 2010 :: How To Find All Unique Values Then Combine In A New Column

Jul 9, 2013

I have a wookbook with serial numbers in column A and barcodes in column B. There are 51940 rows in total.

Is there a way I can search through column A, and for each unique value found , concatenate all of the barcodes that relate to that serial number in column C?

Serial Numbers | Barcodes | Combined Values
-------------------------------------------------------
abc123 abc12300 abc12300,abc12301, etc etc
abc123 abc12301
def456 def45600 def45600, def45601, etc etc
ghi789 def45600

i am using Excel 2010.

View 3 Replies View Related

Excel 2010 :: Find String And Delete Column On All Worksheets

Jul 9, 2014

Why my code is not working. I am working with Excel 2010. It will only delete the column on the active spreadsheet and not go to next worksheet. Not all worksheets contain the word "Broker".

[Code] ......

Not sure if its something to do with Activecell, try After:=ws.cells(1,1) or passing it in as the active cell stays the same i think.

View 3 Replies View Related

Excel 2010 :: Find Total Of Times Word Appears Across All Sheets In Column C?

Dec 19, 2013

I have a single work book with 8 sheets (I am using Excel 2010 BTW) and I am trying to find a total of times a word appears across all the sheets in column "C"

I found this formula on another thread. =SUM(COUNTIF(INDIRECT("Sheet"&{1,2,3}&"!C1:C1000"),"="&H3)) with an example. I made the changes that I needed for my purposes

This worked but only after I renamed the sheets to Sheet1, Sheet2, etc.

Is there a way get the same results from the above formula if all the sheets are named after our reps? Example: sheet1 is named Dan, Sheet2 is Nick, etc?

View 2 Replies View Related

Looping Through Specific Worksheets - Find And Replace

Mar 7, 2013

Where i want to carry out a find and replace specific to different worksheets.

At the moment i have:

Sub Changeme ()
Dim SH As Worksheet
Dim rng As Range
Dim rCell As Range

Set rng = ActiveWorkbook.Sheets("sheet3").Range("A8:C10")

[Code] ........

Where column A contains the tab name, column B contains what to replace and column C contains the replacement.

View 8 Replies View Related

Find And Replace Macro Based On Specific Cells

Sep 12, 2009

After much fretting over this (and many other Excel issues), I've decided to seek out some assistance. I've included an example with columns, because I'm not very fluent in Excel terminology.

View 5 Replies View Related

Find And Replace A Specific Letter/number Combination

Jul 9, 2008

I have a column of references I wish to standardize. Contained within a general text description there is also an order-specific reference number, which is not relevant for my purposes. I wish to find all of these numbers and replace them with nothing (i.e. retain the rest of the description).

The reference numbers are always in the format "P#####/##". Unfortunately these references are in the middle of the text field, not at the start or end, so I can't use a LEFT or RIGHT formula to delete them.

Once these reference numbers have been deleted I will then be able to filter for unique records only. When I do this at the moment the filtering has no effect due to these specific reference numbers.

View 9 Replies View Related

Macro To Find Replace Specific Text In Multiple Sheet Names

Sep 13, 2010

I need a macro that will look for a specific text string in the tab names of the workbook and replace it with a new specified text string (leaving the rest of the existing tab names). In other words, a simple find/replace but applied to all tab names in the workbook rather than cells. Ideally, I'd like it to pop up something and ask for the text to find and the text to replace it with, so I don't have to edit the macro itself each time I want to use it, but editing the macro each time is fine. Either way will be wonderful.

View 9 Replies View Related

Excel 2010 :: Replace Values In A Cell

Apr 24, 2014

In Excel 2010 I am attempting to replace values in a cell, the right two values with "00", but am having difficulties with the correct '=replace' function.

View 2 Replies View Related

Find Multiple Numbers In One Column And Replace With Single Phrase In Another Column

Jan 31, 2013

I have taken over this spreadsheet for my work, and it is basically a statement in excel. What I want to do is find a list of invoice numbers in column B populated from a remittance, and then replace column F to say a specific thing depending on check number and date paying for that invoice. So if a check printed today I would have it replace column f to say paid 1/31/13 check # xxxxx. Currently I am searching for each invoice indivudually and then replacing with check number and date. There are about 200 invoices per month that I deal with, and it is a big waste of time!

For example from this

invoice #1 / reconciled (DATE)
invoice #2 / reconciled (DATE)

To this:

invoice #1 / paid (DATE) check # (xxxxx)
invoice #2 / paid (DATE) check # (xxxxx)

View 2 Replies View Related

Excel 2010 :: Replace Function Missing Strings In Merged Range?

Jun 11, 2014

I've recently been making a macro in visual basic that loops through all my excel files and replaces an old company name to a new company name and It's working great, well except for one thing... It always misses one string in the file and it leaves me with 90% of the file corrected. I think that the string might be a part of a merged range so Range.Find is not able to find it. I was suggested to use this code:

[Code] ......

Because that's the code that is generated when using the replace function in MS Excel 2010, but I keep getting syntax errors?

View 2 Replies View Related

Find Replace Within Excel Formula

Jan 24, 2014

I need to replace A1*FX! with A1/FX! within thousands of formulas (and many variants of A1)

Unfortunately whenever I attempt this is deletes the A1 (or whatever cell is being referenced)

How to stop find replace doing this?

View 4 Replies View Related

Find & Replace In Single Column

Dec 9, 2009

I'm wanting to use VBA to search down a column for a one dynamic value and replace all instances of that value in the column with a seperate dynamic value. My first attempt was this:

View 6 Replies View Related

Find And Replace Certain Signs In Column - VBA

Sep 3, 2013

Column H contains alphanumeric data (codes).

I need a macro that renames all cells in column H starting with the letter "B" by replacing B with "Temp" and thereafter cuts the last two digits of the code. B224501 would thus be Temp2245.

View 2 Replies View Related

Find & Replace With Column Data

May 30, 2009

I was wondering if it is possible to perform a find and replace which would replace data from another column. We have a lot of data fields of our inventory that we exported which we are trying to condense for another program.

Example: I have a description column (AV) that has [[Manufacturer]] within the description. We want to find [[Manufacturer]] and replace with our data column (DD).

This is the data that has our manufacturers name in it. We have several find and replaces to do within the description column besides the above field.

View 9 Replies View Related

VBA - Find / Replace Excel Variable In Word

Apr 7, 2012

I have never used VBA in word before, so I am assuming I am making it more complicated than it needs to be. I have a macro that stores 20 excel values as variables, then opens up a word document. I want to replace values in word with my values in excel. I keep getting an error with the replace part. I do not want to use bookmarks or mail merge. MSWord is a reference in excel VBA.

Code that stores excel variables (Example: Var1=Data1 and Var2=Data2)...
'Opening up the correct word document
Dim WdApp As Object, WdDoc As Object
Set WdApp = CreateObject("Word.Application")
WdApp.documents.Open ThisWorkbook.Path & "" & Range("D1").Value & ".doc"
WdApp.Visible = True

[Code] ..........

View 9 Replies View Related

Excel Script - Find And Replace Data

Oct 16, 2013

I am looking to make an excel script that can find and replace data.

Situation:
A--------B-----------C
Cat------Dog------Banana
Dog------Fish------Apple
Fish------Cat-------Orange

So the macro would look at the data in a cell in column B, then look at the adjacent cell in column C, and replace all instances of that data in column A with what if found in C. So the results would be:

A------------B-----------C
Orange------Dog------Banana
Banana------Fish------Apple
Apple--------Cat-------Orange

But that's not all, I would like it to not change cells in A that already have been changed once! (I'm trying this with changing the background colour)

I am at a complete loss and need to find and replace over 3000 items.

View 4 Replies View Related

Find And Replace Cells In A Particular Column By Using Macro

Apr 11, 2014

I have a excel which contains 5 columns in which 5th column data cells has to be replaced with another set of data which have relationship with other 4 columns data.

View 3 Replies View Related

Find Numeric Codes In A Column And Replace In Vba

Oct 18, 2007

I am using the following vba code to find numeric codes in a column and replace them with the same code along with descriptive text:

Range("Q:Q").Select
Selection.Replace What:="11", Replacement:="11 - GSA"
Selection.Replace What:="10", Replacement:="10 - NYS OGS"
Selection.Replace What:="1", Replacement:=" 1 - Dist Sale"
Selection.Replace What:="2", Replacement:=" 2 - Direct Sale"
Selection.Replace What:="3", Replacement:=" 3 - No Sale: Warranty Exchange"
The problem as you might already see is that when the replacement of "1" happens, Excel will replace the 1 in the 10 and 11. Of course I want to only replace the number 1. Is there a better way to code this operation?

View 9 Replies View Related

Excel 2010 :: Set For Specific Worksheet

Jul 30, 2014

I am using lesson 33 of Excel VBA and Macros with Mr Excel as my guideline. The coding is as follows:

Dim WBO As Workbook 'original workbook
Dim WBN As Workbook 'individual data workbooks
Dim WSL As Worksheet 'List of files worksheet
Dim WSN As Worksheet

Set WBO = ThisWorkbook
Set WSL = WBO.Worksheets("List")
Set WSD = WBO.Worksheets("Data")

[Code] ......

I have indicated above with ( ) the beginning of my problem.

From the workbook with the list of workbooks to open, in each case I want to refer to a worksheet in each workbook
named "Report" and grab all the rows with data exept heading (rows 1 & 2) and 9 columns.

How do I get WSN in the code above to include the worksheet named "Report" or do I need different coding. Using Windows 7 & Excel 2010.

View 1 Replies View Related

Excel 2003 :: Use Find And Replace To Delete Word?

Dec 1, 2005

I'm looking to simply delete certain words that are in cells, without having to delete rows, columns or the entire cell. I can use 'find and replace' and replace the particular word with a space, but I really want to delete the word. I'm using both Excel 2003 and 2000.

View 4 Replies View Related

Excel 2011 :: How To Find ColorA And Replace It With ColorB

Aug 24, 2013

I have Excel MAC 2011 and my spreadsheet was created with multiple cell colors randomly throughout the spreadsheet.

I need to change all the royal blue colored cells to "no color" without changing the data contained in the cell. For example; Cells A5:A38 are blue, A39 is green, A40:A50 blue, A51:60 green, ... Cells B5:B15 are grey, B16:B20 are blue, B21 is yellow...

I can't find the "Advanced Options" for Find and Replace that might have allowed me to specify a color change.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved