**17**

votes

**4**answers

8k views

### How to remove a plain text protecting single quote from all the selected cells in LibreOffice Calc?

I've imported a CSV file having the first column to be date-time values in ISO 8601 format like
2012-01-01T00:00:00.000Z
for the first moment of the year 2012.
Then, willing to make ...

**8**

votes

**4**answers

20k views

### Excel: How do I reference an entire row except for a couple of cells?

I want to be able to sum together the values of an entire row except for the first 2 cells. So something like this:
=sum(A3:A*infinity*)
How do I do this?

**5**

votes

**3**answers

9k views

### Excel: Custom number formatting

I don't know much about the rules on custom number formatting in Excel, and I need to learn more. When I open the related window (Format Cells > Numbers > Custom), there are some predefined ...

**5**

votes

**1**answer

44k views

### Make some cells in an Excel sheet password protected?

I have an Excel 2010 file that I do not want to have a password for, but I do want to lock certain cells so that I do not accidentally edit them.
Can certain cells be made read-only without a ...

**4**

votes

**4**answers

714 views

### Can I recharge a cell phone battery using USB?

Is it possible to recharge a cell phone's battery even if USB is disabled or blocked on the system?

**4**

votes

**1**answer

3k views

### OpenOfficeOrg Calc: enter data into all selected cells?

I want to enter the same data (e.g. "superuser") into multiple cells in OpenOffice.Org Calc (version 3.3.0). In order to do so, I select all the cells I want the data to be entered in. However, only ...

**4**

votes

**1**answer

1k views

### Why do cell phones disturb my speaker?

Sometimes when I receive a incoming call on my cell-phone which is kept very near to my speakers , it disturbs the speaker sound . why does this happen , isn't it safe to keep mobiles near my speakers ...

**3**

votes

**1**answer

104 views

### Excel find cells by formatting?

The countif function has a criteria argument – how do I specify a criteria based on the formatting of cells?
I have a list of math homework questions containing per-page the questions numbers (e.g. ...

**3**

votes

**2**answers

93 views

### Excel 2010: Find duplicate entries in one cell

I have data imported from a literature database (.txt format) into Excel. Unfortunately, in most cases, the authors are listed double in one cell, e.g.:
"Smith, Miller, Patty, Smith, Patty, Miller"
...

**3**

votes

**2**answers

101 views

### Can I insert rows next to a locked column in Excel?

If I lock cells A1:A3000, is there a way to insert rows in columns B-Z?
I highlight them and I don't get the option to insert even though it is selected in the lock options. (Bottom line is that I ...

**2**

votes

**1**answer

10k views

### Using Excel, How do I Make a Column of Cells Equal One Other Cell?

I have a column of cells, all of which I want to equal the value in another cell. I highlight the cell and type = and then do that again below, and then I highlight the cells and drag down but the ...

**2**

votes

**3**answers

67 views

### Adjacent cells replicate format of previous cell

I have a basic spreadsheet set up to monitor my outgoings. When something clears my account I color the relevant cell in so I know its accounted for. However since I upgraded my Office, whenever I ...

**2**

votes

**2**answers

4k views

### Make Excel cell save formula results and not the actual formula?

I have C1 that needs to combine C2 and C3. The problem with this is that is that if I'm importing with SQL it doesn't combine C2 and C3, but instead imports nothing or the actual formula. Is there a ...

**2**

votes

**1**answer

3k views

### How to check if cell contains a value of another cell

Here is the scenario:
On column A each cell has random text within it (names, address, account numbers, etc). Column A extends down to over 40 thousand rows.
On column B I have a list of (account) ...

**2**

votes

**1**answer

21 views

### Excel - Exclude Cells from Computation

Say I have 5 columns of data with 100 rows (so from A1 to E100). For each row I want to compute the averages of the 5 entries while I always exlude one of the entries. E.g. for the first row I would ...

**2**

votes

**1**answer

64 views

### Excel: extracting a number from mixed content cell [duplicate]

How would one extract a number starting with a "£" sign from a cell containing alphanumeric characters?
Example: extracting £450,000 from A1 and placing in B1. See image for example text
...

**2**

votes

**1**answer

38 views

### Shortcut to move to next new content (Excel)

I'd like to know if there is a shortcut to move to and select the last cell in a row or coumn with the same content as the current cell. I.e. ctrl + arrow moves to the edge of the data array, but I'd ...

**1**

vote

**3**answers

6k views

### Remove data from a cell in Excel

I want to remove data from multiple cells in a spreadsheet using Excel 2010, so I only have the email address left.
They are in the current format:
M: 04545 545 545 e: test@email.com h: 01187 475 ...

**1**

vote

**2**answers

158 views

### How to keep Excel from using absolute addresses when clicking a cell while in a “range selection” window?

In any version of Excel (since 2000, at least), you can enter = into a cell to indicate that a formula is about to be entered and then click cell A1 so that the formula says =A1. This is a relative ...

**1**

vote

**3**answers

834 views

### How can I detect if a range of cells contains only identical values or not in Excel?

I have a range of cells and I want a formula that says if all these contains the same values or not.
Usually for two cells I would use if but I want a solution that would work for ranges. I don't ...

**1**

vote

**1**answer

464 views

### Call on a cell in Excel up to the first semi-colon

I am using the =CONCATENATE function, and one of the cells I'm calling on I only want to take the value in the cell up to the first semi-colon. Is this possible, and if so how?

**1**

vote

**3**answers

13k views

### Add drop down list / combo box into excel cell

How would I add a drop down list (or combo box) into a cell on Excel 2010?

**1**

vote

**3**answers

785 views

### Methods to clear a cell in Excel 2010

I'm taking a certification course for Microsoft Excel 2010. I'm taking a class that goes over it and we all just got hit with this question:
61. In Excel 2010, which of the following can you use ...

**1**

vote

**1**answer

149 views

### Dragging a cell reference in intervals

I have data as follows (simplified) in two worksheets on a document:
Sheet 1 data:
A1=1 -- B1=(Blank) -- C1=(Blank) -- D1=2 -- E1=(Blank) -- F1=(Blank) -- G1=3 ...
Sheet 2 data:
A1='Stage ...

**1**

vote

**1**answer

2k views

### How to bulk replace links that are embed to words in Excel cells

I have a huge list of words that have links. All the URLs have text that repeats. I want to mass replace this text with another. Right now, "Replace all" only searches between words, not through the ...

**1**

vote

**1**answer

3k views

### Convert from seconds to minutes in Open Office

I have several cells with a time value in seconds e.g (23, 102, 543, ...)
I am not very familiar with the formula functions in Open Office. How do I address the same Cell-Box with the value in it? I ...

**1**

vote

**2**answers

767 views

### A way to call someone from PC via a cellphone

Is there a way to use a cell phone as a modem and then use a phone software like Classic PhoneTools to call another (cell) phone?

**1**

vote

**4**answers

6k views

### Comma separated values (literally, not csv) in the same cell in excel, put in individual cells

I have a column of cells in excel which contain mails, some only contain one mail as they should but others, have more than one email per cell in this format:
one@example.com, two@example.com, ...

**1**

vote

**1**answer

46 views

### How can retrieve cell address that match criteria?

In column A are various products (A2:A100), in column B are different numbers (B2:B100).
In cell G2 is criteria from column A.
With the formula {=MAX(IF($A$2:$A$100=G2;$B$2:$B$100))}, I can find ...

**1**

vote

**1**answer

421 views

### Excel 2010 VBA only affecting last row in range

I have some VBA code written in Excel 2010 to force padding around the rows in a table, but part of the code only affects the last row in the range. Here's the full code:
Private Sub ...

**1**

vote

**2**answers

5k views

### Excel: if duplicate cell value found in another column then highlight green

Can someone help me, I'm not sure what formula to use.
I have highlighted the cell in the picture to show an example of what I mean.
What I want to do is highlight the cell in column A where the ...

**1**

vote

**3**answers

1k views

### Create a hyperlink from URL and title in Excel

I'm trying to construct a hyperlink from a URL and a name in different cells.
a1 = http://www.example.com/
b1 = example
c1 = <a href="http://www.example.com/">example</a>
What I want ...

**1**

vote

**1**answer

112 views

### Align header with cells whose text is oriented at an angle

Is there a smart way to align horizontal-text "header" cells with other cells below whose text is oriented at an angle?
This is what I tried. Obviously this looks awful. The "Benefits" and "Caution" ...

**1**

vote

**1**answer

42 views

### Use space bar to input a value in an excel cell

Could someone help me with a macro code/formula to enable space bar to input a value in a cell? For e.g., if I hit space bar when I am on a cell, I would like to print "x" in it. Is it possible?

**1**

vote

**1**answer

188 views

### How can I protect and hide the data in a single excel cell using password?

My professor want me to send out an excel sheet which contains grades of all students.
And of course every student can only see his own grade. So he want me to set passwords for the grade cells. Each ...

**1**

vote

**1**answer

34 views

### MS Excel: custom money format

Need to represent decimal number as "## hrn. ## kop.".
Example:
1.2 => 1 hrn. 20 kop.
3 => 3 hrn. 00 kop.
I've created custom cell format:
0," hrn. "#0" kop."
Result is:
1.2 => 1, hrn. ...

**1**

vote

**1**answer

259 views

### Make Excel Row Height Stay when Sorted

I have an Excel 2007 spreadsheet and need to make some rows bigger than others so there is vertical space for a signature.
These cells are colored differently, but the height doesn't stick with the ...

**1**

vote

**5**answers

16k views

### Microsoft Excel 2007 - Cannot Fit All Text Into Cell

Is it possible to fit a large amount of text within a cell in Excel 2007?
I have 1,890 words - consisting of 10,110 characters (without spaces) - that I need to put into a single cell in Excel. I ...

**1**

vote

**1**answer

250 views

### Delete cell content in Libre (Open) Office based on the cell value

I have a huge csv file (tens of thousands of rows) that I need to filter based on different criteria. After trying to find a proper CSV editor, I decided to use LibreOffice Calc. CSVed is great, but ...

**1**

vote

**1**answer

915 views

### Copy & paste a cell along with its name in Excel

Is there a way to copy a cell that also has a "name", and paste it somewhere else so that the new cell also has the same "name"?

**0**

votes

**3**answers

5k views

### Sum only if any one of six cells have a value

I would like a cell (total) to sum 6 other cells only if one of those 6 cells have a value. If none of the six have a value i do not want anything to appear.

**0**

votes

**5**answers

9k views

### How do you add extra value to a cell that already has an existing number in it

I find this hard to explain, but I'm stocktaking beers, spirits, and liqueurs and I want to keep one column for my ullage count for each product. However, as I go through the days, I often come across ...

**0**

votes

**2**answers

538 views

### Excel function for calculating total spent time

I have an excel sheet, where in some columns I have cells of the type "integer,integerM" or "integer,integerH", for instance "1,30m" or "5,2H". For all the column I would like to get an expression ...

**0**

votes

**2**answers

527 views

### VLOOKUP when VLookup Value is a cell populated via another formula

I keep getting a return of NA when trying to accomplish the following:
formula:
=vlookup(left(Q2,3),A2:C20,3,false)
Definitions:
Q2 is a cell that is populated from a formula. Its calculated value ...

**0**

votes

**1**answer

41 views

### minimum of non-zero non-adjacent cells in MS Excel

I know that for finding the minimum of non-zero cells in Excel, I can use
min(if(A1:A10>0,A1:10))
But what if I would like to find the minimum of non-zero & non-adjacent cells?

**0**

votes

**1**answer

19 views

### Combining address function and cell function in Excel

In MS Excel 2013, when I write
=CELL("contents",$B$1)
It is okay, but when I write
=CELL("contents",ADDRESS(1,2))
It results in error. I would like to access the contents of an address. I have ...

**0**

votes

**1**answer

25k views

### VBA code to hide or unhide rows based on a cell value

Heres my code, but its not really doing anything, I dont see anything wrong with it:
Private Sub PG1(ByVal Target As Range)
If .Range("E50").Value = "Passed" Then
...

**0**

votes

**1**answer

226 views

### Excel: while merging column contents using ampersand I “lose” zeros

I need to merge different columns like:
AB 0054 00000137
I do it this way
=A1&B1&C1
It works but my Zeroes get lost.
The text in my columns has been formatted in "personal" with zeroes ...

**0**

votes

**1**answer

55 views

### How to Mirror cells in excel 2013 [closed]

I want to make an excel file for sales management of my company. the excel I have created has 4 sheets and every sheet is handled by different persons.
I want to dedicate the first column of these ...

**0**

votes

**1**answer

33 views

### Excel reformatted numbers to times

I have a spreadsheet stored on a company sharepoint site. Only one person in my team will use it at any time, when they're finished it saves and is available to another user. Periodically when someone ...