Question about Computers & Internet
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.
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
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.
Posted on Jan 02, 2017
Tips for a great answer:
Jun 18, 2015 | Microsoft Office Excel 2007
Mar 28, 2014 | Psion Teklogix 7535 G1 WiFi PDA w/Long...
is a spreadsheet file. By default, each workbook in Excel contains three pages
The term spreadsheet is often used to refer to a workbook, when in
actual fact, spreadsheet refers to the computer program, such as Excel.
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...
The default Excel
file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets
(.xlm files in Excel 4.0).
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.
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).
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.
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
Feb 21, 2011 | Computers & Internet
Jun 26, 2010 | Microsoft Office Excel 2003 for PC
Apr 12, 2010 | Microsoft Excel for PC
Oct 13, 2009 | Microsoft Office Excel 2007
Apr 24, 2009 | Computers & Internet
Apr 24, 2008 | Microsoft Office Professional 2007 Full...
Nov 22, 2017 | The Computers & Internet
430 people viewed this question
Usually answered in minutes!