text

🤓 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...

=TEXT("G" & ". " & G10 & " - " & INDIRECT("G"&L1),"mm.dd.yy") Returns date's serial: G. Image In Date - 44648 Instead of date itself, G column contains that date in it: G. Image In Date - 03.28.22

I'm hoping to convert a month number (e.g. 7) to a month name (e.g. July), is there an easy way to do it? I've found several *competing* theories online of how to do it, *none* of which are correct. Does anyone know if there's an easy way of doing it? I'd like to avoid making a chain of 12 if...

Hello, I have a sheet that needs to search for text in a column, and then return the corresponding value next to it. I need the results stacked together so that there aren't blank rows between results. I can't use VBA for this as I'm actually doing it in Google Sheets. Thank you in advance for...

I appreciate the help with this, which will help me learn. I know I can do this with Query from Table, but I'd like to learn it by formula. I figured out how to extract the numbers within the ( parens ) using left and find. Now, I'd like to work out how to remove only the company names via a...

I'm looking to make a super simple macro that just pulls the text out of a shape and uses that to unhide and open a tab on click. Sub ButtonToHiddenSheet() Dim ShtName As String ShtName = SHAPE TEXT Sheets(ShtName).Visible = xlSheetVisible Sheets(ShtName).Select End Sub I...

Hi, I wasn't able to find the answer to my question online and have no idea what I'm doing in Excel. Out of a spreadsheet with thousands of company names and their associated data, I have a specific list of companies that I need email addresses for. Instead of manually searching for each one...

Hi, I'm looking for a formula that allows me to search for a specific partial text that is part of a word, and then return the characters that start off the word. So for example, I have a cell with information like "English, Maths, Science, Community Skills, 45C/English, 3A/Maths, 5B/Science"...

I am completely new to VBA and I was recently using to get HTTP status for the website using the following code Public Function CheckURL(url As String) Dim request As Object Set request = CreateObject("Winhttp.WinhttpRequest.5.1") On Error GoTo haveError With request .Open...

Hi All I have recently used a VBA code, which works with selenium. The code allows you to use an excel spreadsheet to send messages via whatsapp, automatically. You may have seen the youtube video for the guy who wrote and offers the code, along with the spreadsheet: However I have vast...

Hi all! I have this setup (albeit much larger in reality): Every statement has a sentence with "XYZ employees". Is there a formula that can detect when a sentence says a number, followed by the string value "employees", and then return the value of the number? So that formula can fill out...

Hey All, I have the below table, and instead of having "B", I have formula that goes : If(xxx,"Text", ""), and as it stands B should then reflect: "". When I use the formula: sumifs(range Y,Range Y, "<>"), the formula reverts 3; but if I use sumproduct ((range X <> "")*(Range Y)) the formula...

Hello, so when I download this sheet from the web, it always shows this error "Convert to number", basically in few of columns (where there are numbers) it is stored as different format which does not allow you to sort with number and mathematical operations, I change it manually with...