Question about Computers & Internet

1 Answer

In Excel find/replace multiple cells when using wilcards?

Hello,

My problem is this:

I have a range of cells in a very large workbook that are !C2 !D2 !E2 !F2 !G2 I need to replace the 2’s with the # 4. I would like to replace them all at once instead of each one separately.
I can change them separately using find !C2 replace !C4, but this is taking forever. Is there a way to change all 5 (C, D, E, F, G) all at once?
I have used the wildcards * ? [ ] (C-G) and none of them have worked.

Thanks,
Marcia

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Novelist:

    An expert who has written 50 answers of more than 400 characters.

    Governor:

    An expert whose answer got voted for 20 times.

  • Expert
  • 85 Answers

I don't recognize cell names beginning with an exclamation(!). It usually separates sheetname from cell name, like sheet1!C2. (Probably don't want the "!".) Usually you use names like C2 or $C2 or C$2 or $C$2 for movable cells or partially or fully absolute addresses. The last form doesn't change on moves or copies.
With find and replace you could use just the partial string 2 for find and 4 for replace.
Better yet, copy the cells you want as source and you can just paste the new location and Excel will adjust the non-absolute parts of addresses. (Drag and Drop may apply but Copy and Paste always works.)
There are restrictions on non-contiguous selections. -Ken

Posted on Jul 15, 2009

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

3 Answers

Excel workbook error


I came across this issue today. An update to the Office Compatibility Pack that was still on a computer caused the default PROGRAM for .docx and .xlsx files to be the Microsoft Open XML Converter program and make the "Default Programs" in Control Panel think that Excel and Word were actually the Microsoft Open XML Converter scholarship essay writing assistance program as well.UNINSTALLING the Office Compatibility Pack in Programs and Features and then a simple reboot fixed the issue.
Also:
1: Try to repair it manually when MS Excel does not automatically STARTS File recovery mode.
Click the Microsoft Office Button, and then click OPEN.
Now select the corrupted workbook that you want to open.
Click the arrow NEXT to the Open button, and then click Open and Repair.
Choose either Repair (to recover as much of the FILE data) or Extract data (to extract values and formula when repair process is not successful).
2: Open with Open Office: Try to open your Excel file in Open Office. It is an open-source Office suite that is able to open & SAVE Microsoft Excel files.
3: Save in HTML Format: Open your Excel file and save it in HTML format. By saving the workbook in HTML format, you may be able to filter out the corrupted elements.
4: Save in SYLK Format: Open your Excel file and save it in SYLK format. By saving the workbook in SYLK format, you may be able to filter out the corrupted elements.
5: Try 3rd party software like Excel Repair Toolbox
link: https://www.repairtoolbox.com/excelrepair.html

Jun 18, 2015 | Microsoft Office Excel 2007

1 Answer

I have a project going in my company. I want psion teklogic to automatically send the scanned data into Excel. Please help me in understanding how can I do this ?


you may need an ocr to excel software converter
http://www.simpleocr.com/OCR_to_Excel
in excel you would have a work book that you put the resulting scan into as an excel format. Then you have another workbook that is referenced to the workbook and particular cell with part number
then you would have a workbook with a list of cells part number and pdf files .
then lookup function would take part number and use it to lookup from the reference list.

Mar 28, 2014 | Psion Teklogix 7535 G1 WiFi PDA w/Long...

2 Answers

What is a workbook?


A workbook is a spreadsheet file. By default, each workbook in Excel contains three pages or worksheet

The term spreadsheet is often used to refer to a workbook, when in actual fact, spreadsheet refers to the computer program, such as Excel.

So, strictly speaking, when you open the Excel spreadsheet program it loads an empty workbook file consisting of three blank worksheets for you to use.


Jun 25, 2011 | Microsoft Office Excel 2007 Full Version...

2 Answers

What is exel sheet extension in office 2010 ?


Excel Workbook

.xlsx

The default Excel file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Workbook

.xlsm

Uses the same basic XML format as the Excel Workbook, but can store VBA macro code. Users saving an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in Excel 4.0) are prompted to use this file format.

Excel Template

.xltx

The default file format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Template

.xltm

Can contain a VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0). Workbooks created from this template inherit the VBAProject part or Excel 4.0 macro sheets that exist in the template.

Excel Add-In

.xlam

A supplemental program that runs additional code. Excel add-ins use the Open XML file format to store data, and they support using VBA projects and Excel 4.0 macro sheets.

Feb 21, 2011 | Computers & Internet

1 Answer

Hi. By the grace of Almighty it is hoped that you and your family members would be in good health. I need a link to download a multiple sheets Excel Workbook to manage our daily sale, inventory and...


Here are your links Sales
http://www.brothersoft.com/sales-management-report-spreadsheets-for-excel-366701.html
Inventory
http://www.brothersoft.com/downloads/inventory-spreadsheet.html
Purchase
http://www.spreadsheet123.com/ExcelTemplates/purchase-order-template.html

Jun 26, 2010 | Microsoft Office Excel 2003 for PC

1 Answer

Setup multiple spreadsheet pages


Do you mean to display multiple sheets at the same time? Please check out the solution provided below (this applies to Excel 2003)

1.) To view multiple sheets in the active workbook, click New Window on the Window menu. Switch to the new window, and then click a sheet you want to view. Repeat for each sheet you want to view.

2.) On the Window menu, click Arrange.

3.) Under Arrange, click the option you want.

To view sheets in only the active workbook, select the Windows of active workbook check box.

Apr 12, 2010 | Microsoft Excel for PC

1 Answer

Excel 2007: Conditional formatting


did you put the sheet name in your reference? ex =Sheet2!A1 or you can name the cell ranges on the other sheets and use the cell names in your conditional formatting formla.

May 08, 2009 | Microsoft Excel for PC

1 Answer

Copy and paste between different workbooks


There should be 2 paste options when you right click in the new workbook - 'paste' and 'paste special'

choose 'paste special' and make sure that 'All' is selected not 'values'

Apr 24, 2009 | Computers & Internet

1 Answer

OFFICE XP EXCEL SHEET OPEN VERY SLOW PROBLEM


If you have linked one workbook to only one other workbook, I would suggest opening both. This should cause the main one to update basically instantly, and eliminate the timing issue. Otherwise, you might try looking at possibly storing both files in the same folder - it could help. Additionally, depending on what you want the sheet to do, you could set it to update only when you tell it to, rather than automatically - this allows you to control the timing of any waiting that happens. However, unless there are a large number of cells and multiple workbooks involved, it should not take that long... If you need further help, just let me know. Thanks for rating FixYa!

Apr 24, 2008 | Microsoft Office Professional 2007 Full...

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

430 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...