1. I

    Mass Export Whatsapp chats to Excel

    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...
  2. Jyggalag

    Get formula that pulls a number from a sentence in a cell

    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...
  3. I

    Sumifs vs Sumproduct on partially blank cell

    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...
  4. A

    Covert Data into Text with VBA Code

    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...
  5. B

    Excel formula not calculating

    Hi, I tried to simplify my issue: I wrote in my cell C2 the following formula: '=SUM(1;2) When I copy paste this formula in cell C4 I can read =SUM(1;2) in the cell but it does not calculate it. I need to click in the formula and just press enter for it to calculate. I assume the quote is...
  6. E

    Box parts of text within cell

    I would like to box parts of text within a cell. I know it is possible to format the font of partial cell contents but is it possible to box it. I have attached a picture of what i would like but in just one cell. using Office 365
  7. E

    Display Text when Button is checked

    i dont seem to make progress bcs I dont have experience. Maybe you guys can help me out. If a button is checked i want it to display the text in a free cell from A1 to A14. I tried .TypeText „…“ but that does not work. Help is much appreciated
  8. M

    Excel sees my AM/PM times as text

    I've formatted my cells as time. When I enter 3:15 Excel converts it to 3:15 AM. That's ok. But if I input 3:15 PM Excel accepts it as text. If I type 15:15 Excel properly converts is to 3:15 PM. I have no idea why I can't type the AM or PM and have Excel accept the value as a time.
  9. J

    Formula > Text > Formula

    I am working on two sheets and I need help finishing a formula to text to formula function. Sheet 1: Cell H48 formula: =CONCAT(TEXTJOIN(",",TRUE,H2:H47),",""""",J46,) Cell H48 output (Text)...
  10. D

    Change Number Format of textbox calculation

    Hello. I am very new to VBA so i have a question. How do i change number format of the value for textbox total cost? i know afterupdate but i tried and it work only on textbox that the user input data in but how do i change the number format of value that is calculated from data input by...
  11. A

    how to copy cell value from one sheet to another with the same formatting

    hello, community. I'm trying for 2-3 days to make a Microsoft Access Database for a schedule at my work - 24/7 x6 people. it's too hard for me and I'm back to excel. at the moment I'm trying to bring the information (text) from sheet 2 to sheet 1 but i want to keep the text formatting ( only...
  12. S

    Macro for summary making

    Sub Import_Text_Files() Dim FilesToOpen Dim x As Integer Dim wkbAll As Workbook Dim wkbTemp As Workbook Dim sDelimiter As String Application.ScreenUpdating = False sDelimiter = "|" FilesToOpen = Application.GetOpenFilename _ (FileFilter:="Text Files...
  13. S

    Formula to make queue with text

    Question is there a formula for the below example? From this: Queue Name Order No. Jack N01 Jenny N02 Jenny N03 Kimmy N04 To this: Queue Name Order No. N01Q01 Jack N01 N02Q02 Jenny N02 N03Q03 Jenny N03 N01Q02 Kimmy N04 1. So A2 gets the value of C2 and add...
  14. F

    VBA - Import text to specific sheet, with delimited with file dialog prompt

    Hello I'm trying to import a text file into a specific sheet, where it should do a Text to columns with the delimiter set as a space. What I would like to do: Clear all data in Sheet "SVKData" File Prompt for a text file, that imports data into "SVKData" the data should just be imported into...
  15. Ruts

    Updating Text Format in a Shape using VBA

    Hey everyone, I wrote this bit of vba quite some time ago (2017) to run a little bingo caller for a social team where I was - keeping excel up to date wasn't something they were good at - so the version at the time worked. They have now updated to O365 and the reformatting of the text in the...
  16. R

    Find a text in a sentence column

    Hi, I'm doing my first post here. Please excuse me if this is silly. I have col A and col B as text fields. In col C I have a query list. I'm trying to find if the text values in both col A and col B exist anywhere in col C and then return a true or a false. Please see the attached sheet...
  17. J

    Format bolded text only.

    Hi! First time posting here! I have been struggling with a very specific and probably weird issue that I am not sure of having a solution. The problem is related to text that is initially in word documents. Likewise, I have today asked for advice in a forum connected to Word VBA...
  18. M

    Pipe-delimited Text File Format

    Hi, I am using the below code to Generate a text File in pipe Delimited format. Sub ExportTxt() Dim UsedRows As Long Dim UsedColumns As Long Dim R As Long, C As Long '// Define a suitable file name Open "E:\Folder\" & "TD.txt" For Output As #1 With ActiveSheet...
  19. D

    Insert text with connection to other cells

    Hello, I have a table with some columns, and I would like to make some text below it connected to some cells. Example: Name Number Street Age Bob 2 Close 24 Rob 3 Far 64 Robert 5 Near 32 Bobert 7 Here 24 Idea is to place below something like this: Range("A6").value="Hi"&"...
  20. O

    recognise format of code in Power Query to extract

    >10k of rows of short sentences have within then, usually, a code. I need to extract this code, but how do I get PQ to recognise its format, which is: 230F-115-04 301F-115-05 30A-115-26 30F-1180-02 30F-118-03 30F-1252-04 130H-1252-05 30F-1252-18 30F-126-01 40G-127-01...
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