single cell

  1. M

    Find total of columns of each row in a single cell -Excel 2007

    Can anybody help me to find total of all the horizontal elements in each row of an array in a single cell without VBA code.. Values shown in the following table are basically the elements of an array derived from other excel formulas. Purpose is to find the row number at which sum of...
  2. JacksonTriggs

    Extract Numbers and Text from Single Cell with Multiple Numbers & Text

    Hi all! Despite searching for similar posts, I have not found a solution to the following problem regarding a single cell with a very long string of multiple numbers and text. Here is a part of it: 118 A&E 131 AMC 184 Animal Planet.... How can I extract this string into rows with two columns...
  3. M

    Can I sum text values like numbers from a single cell?

    Below is a screenshot of a workbook with a sample of what I am trying to do. I have a sheet with a tab labeled "MATERIALS". The sheet contains a list of materials in column A and in column B is the corresponding value of the materials On a second sheet with the tab labeled "PROJECTS" I have a...
  4. D

    Need macro/VBA/Sub... that will paste data from the clip board into a single cell

    This macro/VAB/Sub... needs to be able to paste data into a single excel cell. The copied data may be one word or multiple paragraphs from a word document. Either way it needs to be pasted into one single cell. The code needs to pick up from this point: ' Paste info from clipboard starting at...
  5. S

    Storing an array of dates into single cell

    Hello, I am trying to store multiple dates in a single cell as an array, similar to ={1,2,3} and due to the structure of my table I can't use more than one cell for the content of the array. The dates are formatted like this: 14-9-2018 14:00 (d-m-yyyy hh:mm) I can't store the dates as text...
  6. N

    Delete data in a single cell

    I have what should be a simple problem but I have been racking my brain trying to figure out what I am doing wrong. I collect data using a wireless device that sends a signal to the PC and thus into Excel. Once the number is populated into a cell, it automatically moves to the next cell to the...
  7. R

    Return values from string that match defined range within a single cell

    How can I search through a string and return only the values that are in a defined named range within a singe cell? Ex: assume cell A1 contains the string "blue_yellow_red_orange". However, I want cell B2 to return only those substrings that are present in my named range "Colors", which contains...
  8. 2

    From column to single cell

    Hello Friends, Could you please help with VBA code for doing following: 1) Read list of values in a single column 2) Enter all those values delimited by semi colon in to another single cell. For example following Input values in Column A Input Values (Heading) 100 200 300 400 Will appear in...
  9. C

    Cell with comma seperated values and vlookup

    1st table/report has cells with single values as well as multiple values separated by comma. <tbody> Identifier AA XY,AA,YX BE RE,WX,EW,XT AB,ER, </tbody> if any of the values in the cell is there in the 2nd table I need to filter the 1st report. 2nd table/report <tbody>...
  10. J

    Removing Duplicates in a single cell with multiple separator

    Hi I'm having a helluva time with excel since I remove duplicates from 33k row of entries from column A to P Now I came across an issue, I need to merge multiple address in a single file row how ever each entry have multiple name, I need help in removing those multiple names after merging...
  11. A

    Prevent Duplicate Entries in Single Cells from UserForm with Embedded ListBox - time sensitive

    Hi All, I have scourged the internet to no avail. I am trying to do something that seems very simple: I am using a multiple selection listbox which is embedded into a UserForm. (It is a check-all-that-apply form linked to a DV list). All I would like to accomplish is a way to prevent duplicate...
  12. C

    Multi selection to a single cell and in a combined cell

    I need for my multi selection in the data validation list box to populate in the columns to the right in a single cell and still continuing to populating in the same cell. Below is my code any help is appreciated. Private Sub Worksheet_Change(ByVal Target As Range) Dim rngDV As Range Dim oldVal...
  13. N

    Multiple indent levels in a single cell

    Hi there, I'm looking to create multiple levels of indent in a single Excel cell, as a way of displaying hierarchy of information. Here's the situation: I'm currently preparing a list of files and am using an Excel spreadsheet to keep track of each file. Each line in my spreadsheet is a...
  14. T

    Conditional Format each row based of a cell at the end of each row

    I am trying to conditional format each individual row, based on a checkbox value (True or False) at the end of each row. For the first row (row #2), I linked the checkbox to cell (o2) o2 reads (True or False), depending whether the box is checked or not. I selected the portion of the row that...
  15. I

    Within single cell, return text value from between 2 consistent known border values

    Hello, everyone. My first post/question. Thank you in advance for the help. I need to determine unique company names from within a list of clients, 12,000+. There are numerous variations on how the company names are presented. I don't feel like trying in Excel to go after disambiguating...
  16. K

    Match index & concatenate help!!

    Hello All, So I want to return a text value based on 4 criteria. I can do this with the Index Match function, however I want to concatenate ALL text values found in the column that match the 4 criteria into a single cell seperated by "; ". I desperately need help on this! The data would look...
  17. K

    Need to Concatenate Array with Index, Match function so all text values show in SINGLE cell

    Hi All, I'm beyond frustrated trying to get multiple text values to appear in single cell. This is the formula I have at the moment and the goal is to return the audit name, which it will do but only if all conditions are met and for one single audit name. =INDEX('Master Audit-IR...
  18. M

    Store and retrieve multiple values in one cell

    Thought I'd share this. I have been looking for a way to store multiple values in a single cell while having that cell's value be and display the first, or primary value. I found a lot of ideas that just didn't work but I finally came up with my own that does. In the VBE add a module and creat...
  19. R

    Combining multiple text cells into dedicated single cell, and inserting line break to separate text bulk in the dedicated single cell?

    Hello, I need to combine multiple product description texts which are in their own cells into a one single dedicated overall description cell which will encompass all the bulk texts from those separate cells, however not make all the text flow in single string without line breaks. Required...
  20. H

    Adding 2 numbers in the same cell to another defined by a word

    Hi guys. I'm really sorry if this question is a common one, and is already answered on the forums. I don't know how to word my question properly in order to make use of search features. The question: In Cell A I have "+1 Bananas / -1/2 apples" in cell B I have " -1/2 Bananas / +3 apples" I...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top