text

  1. L

    VBA code to copy data from Excel by rows to multiple text files

    Hi, I would like to the have the VBA codes to copy data from MS Excel, paste into Notepad and save as text file format (.txt). Please refer to steps below. I have an MS Excel file with 2 worksheets: Fruits and Vegetables. 1. In worksheet: Fruits, Col A to F are the metadata information and Col...
  2. A

    Search for texts in adjacent cells and highlight

    Hello all, I'm quite new to VBA searching for guidance. I was wondering if anyone had an idea how to write an excel VBA script that would do the following: 1. Search column B for a cell containing "Checker Plate". 2. And if the adjacent cell (Column A) contains a "6" or a "9" then highlight...
  3. E

    Find the 1st/2nd/3rd Common Text w/ Criteria

    Hi all, Looking for a formula that will give me the result of the most common text within my dataset. I currently have, for the first common text result the following formula : {=INDEX(tblMain[Placement Provider],MODE(IF(tblMain[Reporting Fin-Year]=RIGHT(E4,5),IF(tblMain[Placement...
  4. B

    Issue about Protected workbook and cell editing function

    :giggle:Would like to ask for your suggestion for this case: Once the sheet is protected, the cell cannot be edited when I come back to it Let me input text: test1 When I try to edit again, the original text would be deleted and the cell is blank Anyway I can fix that? Even the workbook...
  5. C

    ExcelSum Column Containing numeric and alpha text

    Hi, I am trying to create a sum formula that will sum a column which contains a mixture of numeric and numeric an text entries. I am using Excel 2016 and I have a column of financial figures, which I know I can use the =sum function to calculate the total of these figures, however, some of the...
  6. B

    Finding the last text value based on cell value in another column

    Hi all So I have a table of data - here is an example: A B C 1 Code Stage Final Stage 2 455 Stage 1 3 455 Stage 2 4 522 Stage 1 5 522 Stage 1 6 616 Stage 1 7 616 Stage 2 8 616 Stage 3 9 616 Stage 4 What I'm wanting in column 3 is a formula to return the...
  7. V

    Unique ID between two date ranges

    Hello, Would like assistance to run a query in Access for the table below, where the ID is a text format. Date ID Value 4/15/2020 ABA 2.00 4/15/2020 NHB 1.00 4/19/2020 BBB 0.222 4/20/2020 RRRf 1.55 5/1/2020 NNN 9.55 5/2/2020 JUY 2.22 5/2/2020 YYY 2.22...
  8. alansidman

    Want to Put Text into a Pivot Table instead of numerical data

    Have you ever wanted to put Text into the fields in a Pivot Table instead of Values. Well, I found this link where Bill Jelen shows you how using Power Pivot at the site Strategic Finance. Fairly easy to follow. https://sfmagazine.com/post-entry/ju...a-pivot-table/
  9. S

    Format text between two bookmarks in word (VBA)

    Hello, i hope you all are well. I am looking for a way to format text (e.g. size, fond and line spacing) between two bookmarks ("Start" and "End") of a word document using VBA. Do you have ideas / tips how i can solve this problem? Thanks in Advance and best regards, Sarah
  10. D

    Pivot table text not values

    Hello everyone, I am using Excel with a table dump from ERP system. In the example below I am trying to create PT that returns the text value instead of number or formula. In the column ADHOCV all the values under should be ADHOCV not 0. Is this possible? I can do find and replace but this...
  11. H

    Find and Replace Loop Using Spreadsheet

    Hi all, Sorry for the beginner VBA question - I've been stuck for a while and haven't been able to adapt any answers from this forum to quite get the results I would like. I have a range (B46:C54) on multiple sheets that contains values that need to be used in a find and replace. B46:B54...
  12. MrDB4Excel

    Text Extraction

    During the course of extracting the date and time data from this Excel sheet into a word document it adds a tab character between 2020, the @ and the time, in this case, 11:40. So I first tried using the concatenate but it inserts numbers instead of date and time formats. Changing the format of...
  13. B

    Format decimal as number of months

    Hey everyone, I want to format a decimal/fraction as a number of months. For example, I'd like to enter "=1/12" into a cell and have it show "1 month," or enter "=1.5/12" and have it show "1.5 months." Is this possible? Thanks!
  14. R

    Issue with Text in Shapes

    Hello, For some reason whenever I open up my workbook, the text in my shapes has automatically moved to the back so that it appears like there is no text in the shapes. So every time I re-open the workbook, the first thing I have to do is click on a shape and send the text to the front. This...
  15. R

    Create random list then keep it unchanged

    Hi, I'm using randbetween() to create a random list of ten numbers. Repeats are ok, so it's just randbetween(0,300) in every cell. After I have created the list (and without using VBA) I want to keep that list as text. So I'd want it to generate the ten numbers but then somehow keep them as a...
  16. G

    vba to shrink to fit text in a text box

    Hi I have a text box that is a fixed height and width, and has 2 lines of text. The text itself is from a cell and is variable, text lengths could be anything from 7 to 40 characters. I need the text to fit either on one line or 2, but for the text to fill the lines depending on how many...
  17. F

    Function count if for text in textboxes VBA Excel

    Hi, I am doing a userform where I have 8 textboxs named ddc, example: ddc1, ddc1...ddcn. then I have another textbox name quantcoup, that is the textbox I want to receive the count if of everyone of the ddcs that have text in it throughout a command button. Also, I want that the count if detect...
  18. B

    Code for TEXT gets Bold When its get typed anywhere

    Dear All Experts. Please forgive my english as its not my native language. I am in a situation where i want to get a certain word " Pending" as bold and italic whenever i type it on that particular sheet. All the text contains in one cell with many other words , but everytime i type pending i...
  19. S

    Multiple Cell Check without VBA

    Hi, I have an hard time being able to figure out a solution to my issue and would like to see if anyone can help or has ideas of how this challenge can be resolved. I am trying to find a formula that is able to tell me if a cell has changed from a number to a text (horizontally) resulting in...
  20. M

    How to make a row auto populate

    Hello, Thank you in advance for your help! So I would like to have a separate sheet for certain data that is entered in another sheet, but all located in the same book. Is there a way to do this? For instance, if the text in cell D2 matches a certain criteria, then excel will auto-populate...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top