text

I've got a data set of 6,133 rows with cells of dates in the following format: Cell A1: Status A-2022-02-03; Status B-2022-03-11; Status C-2021-09-10 This is an example of the content in a given cell and I want to separate the statuses and their respective dates into separate columns (by using...

This should be really simple, and I just can't get it. I am very familiar with sumifs, but the issue is that my sum range is text and my criteria are numbers. So I always get a zero return. =sumifs(A:A,B:B,C1) Need to return the ttt A B C ttt 1000 1000 rrr 1111 eee 2222

Hello, I'm trying to create a function called TextByColor using VBA. The purpose of this function is to read through one of my sheets called "JOB CODES" and the return all the cells with a white or yellow cell background to a sheet called "TV". The function should read through all of "JOB...

Hello All...I got successfull vba code to copy the worksheet to different workbook. In one worksheet cell have text with color (Title is orange, Status is blue, Plan is black). But when I check the saved copy, the Title text color change to blue...the rest of texts are correct. The funny...

I am looking for a macro or formula what can identify a cell what contains combination of numbers and letters into a word The combination of letters and numbers is on another sheet than the destination word. The sheet with the combination is in sheet what is called "Ullage Report" and this is...

Hello Excel Masters I'm looking for a formula to convert the below text in cell A1 into the date Mar 20 A1 = March 20, 2023 at 10:21AM The formula needs to work for any month and day, for example in 6 months the formula would convert September 21, 2023 at 11:21AM Thank you in advance

I work for a company and we have type up orders for customers. The way the customers give the info can vary so I tend to use Excel for bigger lists. Sometimes, it's not nice and puts it all into a single cell. I don't know exactly where in the cell the item number or if the number is by itself...

I have a csv file that I need to manipulate so that I can imported into another application. I need to add a comma & a space to the end of each cell with data in it (minus the header row) & then export the entire range into a single line in a text file. For example, the contents of column A in...

Hi, I have recorded a macros Sub WarehouseRecieved() ‘ ‘WarehouseRecieved Macro ‘Booked in at the warehouse ‘ ‘ Keyboard Shortcut: Crtl+w ‘ Range(“Q21”).Select ActiveCell.FormulaR1C1 = “Yes” End Sub BUT!! I want to select a different cell (column b) run the shortcut and yes to appear...

Hello! Today is my first day exploring VBA coding, and I'm having trouble with the below 'if/then' VBA code (also attached a screenshot). In short, what I need is for data in Column E to automatically populate according to what is in Column D. For example, if any rows in Column D read...

I am creating a schedule within excel with days along the top, time down the left and activities populated in the table. The column headers/dates are not stored as dates, but as unique values based on our calender (e.g. Week 1 Mon, Week 1 Tue). I would like something that means if I type in...

I have a need to return a combination of two figures in a single cell, one non-decimal and another in a percentage. =GETPIVOTDATA("Count of Reviews",'Tester'!$A$46,"Age Band","65+","Time Status","Not Overdue")&" / "&TEXT(GETPIVOTDATA("% Overall Overdue",'Tester'!$A$46,"Age Band","65+","Time...

🤓 Good day my fellow nerds, I need help so I came here to see what Master Nerd could be so kind to solve this issue I am having. What I am trying to do: Using VBA, I would like to pull text from one cell to another based on a Start Date. Example: Text in Cell B11 is "Feed them cheap...

🤓 Good day my fellow nerds, I need help so I came here to see what Master Nerd could be so kind to solve this issue I am having. What I am trying to do: Using Conditional Formatting, I would like the = function to pull text from one cell to another based on a Start Date. Example: Text in...

🤓 Good day my fellow nerds, I need help so I came here to see what Master Nerd could be so kind to solve this issue I am having. What I am trying to do: Using the = to pull text from one cell to another. Example: Text in Cell C271 is "A Briefer History of Time". When I go into another cell...

Hi! I've just been Googling excel forums trying to find a way to do this. I just want to make a cell auto-populate a body of text based on a dropdown menu selection. I know how to do that, though... However, I want to be able to EDIT the text that populates...and I DON'T know how to do that...

MATCHES is a powerful enhancement to the Excel's built-in MATCH function and returns the relative positions of all items in a one-dimensional array that match a specified value Excel's built-in MATCH function returns the relative position of the first matching item in a one-dimensional array...

ISXTYPE, companion to XTYPE, is a powerful alternative to Excel's built-in type-based conditional functions such as ISNUMBER, ISTEXT, etc., while packing other useful features as well ISXTYPE was designed to provide conditional output after assessing the precise and high-resolution data type of...

XTYPE outputs the precise data type of a cell/range or the elements of an array beyond the resolution of Excel's TYPE() or CELL("type",) XTYPE was designed to provide detailed and high-resolution information about the data type that a cell or cells of a range/array contain. Thus, it is...

Greetings Excel Community, I have numbers formatted in the following Text or general format: 20221026.. I am trying to format it as mm/dd/yyyy.... I have used a formula as follows but it is not generating the correct output: Formula is =DATE(LEFT(G2|4)|MID(G2|5|3)|RIGHT(G2|2)). I am including...