text

  1. L

    VBA - Overwrite current data with text file data

    Hi all I have the following code that works to an extent. Unfortunately, it inserts the data and shifts all other cells to the right. I need it to overwrite the existing data. Any help is appreciated! 'Import text dates Sheets("Split Request").Select Set ws1 = ActiveSheet...
  2. S

    Help with automation

    Hello guys, I really need help solving this, it would save me tons of hours. I will explain what I need to do. I have about 400 txt files that look like this: I did some notes with red text: And I have to format this data so that it looks like this: Like I said I have 400 text files which I...
  3. D

    Copy Duplicate and Remove/Update Original Text

    For each row where there is text in column E, copy the entire row and insert it below the original row. Then remove the text in column E from the row that was copied.
  4. S

    Return Text based on Max Sum of number values by month

    Hi, This is for Excel. I need a formula that returns the text when using a sum max for a number by date. In the below example, AA02 is the answer for January 2023 b/c 4,120 is the max sum (3,995 + 125). cell A1 1/31/2023 2/28/2023 Result AA02 CCC data set Month Year SKU total...
  5. E

    Extract cell content into separate columns

    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...
  6. G

    Return Text Based on Number Criterea

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

    Trying to create a TextByColor function

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

    Copy sheet to workbook the text color in a cell dont follow.

    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...
  9. S

    Looking for a code or formula what can identify any text and change this into a specific word

    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...
  10. M

    Help With Date Stored as text to Date

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

    Extract Text Matching a Certain Sequence within a Cell

    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...
  12. M

    Append character to cell & export column range as a 1 line text file

    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...
  13. E

    Adding text to different cell using Macros

    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...
  14. K

    VBA 'if/then' Code Error

    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...
  15. M

    Macro/VBA to add text from another cell into current cell when I type a certain value.

    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...
  16. E

    TEXT to return "0 / 0%"

    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...
  17. CubeMonkey

    VBA to pull text from one cell to another.

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

    Possible Conditional Formatting use, to pull text from one cell to another.

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

    Text from one cell to another using =

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

    Editing Auto-populated Text

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

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
Back
Top