rept

  1. A

    Help With User Defined Function

    I haver a user defined function to take the second to last word in a string and add 1 to it. When I run the macro with the function in it, I get "Sub Or Function Not Defined". When I go to the debugger, the "Rept" function is highlighted. User Defined Function: Public Function SECONDWORD(sw...
  2. J

    is there a rept() array formula. I need this result

    A1 = 4 B1 = x A2 = 2 B2 = y A3 = 7 B3 = z I need C1 to look like this xxxxyyzzzzzzz this is a simple example. my real data as 200 plus rows. I was going to use rept(B1,A1) & rept (B2,A2 etc.... but that's taking too long
  3. J

    vba query

    I use the following formula to extract postcodes from addresses and it works perfectly. TRIM(RIGHT(SUBSTITUTE(A2,"",REPT(" ",10)),20))<o:p></o:p> However, when I insert the same formula in a vba loop, it does not allow me to execute. REPT is highlighted and the dialogue box says "Compile...
  4. M

    a text formula that i cant crack!

    I am trying to make a formula which basically says "find the first word that starts with G then choose the word AFTER it" but i cant configure the formula correctly, i am a bit of a novice! i can do it by combining IF statementslike this: =IF(TRIM(LEFT(SUBSTITUTE(MID(B4,FIND("G",B4),LEN(B4)),"...
  5. J

    How to colour box based on value

    Hi there Need help from all excel guru out there. Have done some googling but nothing show up what I want. What I need. The formula is similar to REPT. But this formula can only create the number of symbol based on value. What I want is to colour the number of cell on the right based on...
  6. X

    Extract multiple words that contain certain characters

    Hi all, Need help with the above concern. Here is an example data source: <colgroup><col></colgroup><tbody> PS1001 TX1001 TX1001 PS1001 SECTION BE 4 12 S PS1001 TX1001 TX1001 PS1001 SECTION BE 4 12 S PS1001 TX1001 TX1001 BS1001 SECTION BE 4 12 S PS1001 TX1001 TX1001 PS1001 SECTION BE 4...
  7. M

    Need Macros for Given Formulas

    Hello Guys, I need macros for the below mentioned formulas. Please help. <colgroup><col style="width:48pt" width="64"> </colgroup><tbody> <colgroup><col width="64"></colgroup><tbody> =TRIM(RIGHT(SUBSTITUTE(IPC!A2," ",REPT(" ",90)),270)) </tbody> =LEFT(IPC!A4,FIND("...
  8. A

    Check repetition of text in a single cell in excel & delete them to avoid repetition

    I have thousands of rows like that - These are the keywords <tbody> A1 NEW NIVIA TOP GRIP BASKETBALL SIZE 7 OFFICIAL STREET A++ QUALITY BASKETBALL <tbody> A2 New IXO Collated Screw Gun (Cordless) home use screw gun cordless for everyone <tbody> A3 Set of 3 stainless steel soup pasta salad bowl...
  9. K

    Has anyone seen plotting data like this?

    The blue dot moves according to the average width. The formula looks like this; =IF([@Width]<10.7,LArrow,IF([@Width]>25.1,REPT(" ",34)&RArrow,REPT(" ",([@Width]-10.7)*2.42)&Dot)) I was just curious how something like this is done. <attachment></attachment><attachment></attachment>
  10. N

    Require Correct Syntax using .Formula = "=Substitiute...." between two sheets

    Hi Can anyone help me with correct syntax for the following ActiveSheet.Range("B1").Formula = "=SUBSTITUTE(A1,TRIM(RIGHT(SUBSTITUTE(A1,""."",REPT("" "",255)),255)),TRIM(RIGHT(SUBSTITUTE(A1,""."",REPT("" "",255)),255))+1)" Instead of using ActiveSheet. Range would like to use Sheet1 and...
  11. W

    Extract Limited Single Word from Alphanumeric

    Hi Guys, I need help in the complex scenario. I have database of names, unfortunately, there was no proper way on the text input. So I need to extract any single word name from each cells. The cell will include more than 1 words, will have numbers (which need to be excluded), and limit the...
  12. B

    Run Macro if text added to a cell that contains a number

    Hi all, Ive managed to get work worksheet to only calculate a cell if text is added. This allows me to plot a suppliers delivery and only consider it once I add "- arrived " eg below A1 = 1000 / AO1 = 0 ( Using the following formula -...
  13. L

    Is UDF volatile or formulas?

    Hello dear MrExcel, Is this formula volatile: =IF(ISNUMBER(SUBSTITUTE(LEFT(SUBSTITUTE(REPLACE(B33;1;AGGREGATE(15;6;FIND({0\1\2\3\4\5\6\7\8\9};B33;FIND(" ";B33;SEARCH("cmr:";B33)+5));1)-1;"");" ";REPT("...
  14. P

    REPT Function Bar Chart

    Hi, I'm trying to use the REPT function to create bar charts in cells to show project completion status. This works fine when I place the █ character in a cell and then use a reference to that cell in the REPT function. However, I would prefer to use CHAR to locate the character so that there...
  15. T

    Vlookup/match/rept error

    Hi all I have the below formula Worksheet 1 The column A contains the dates from oct to the end of the year, columns B - AP contain trucks and the destinations they went to on each date, Row 96 contains the last destination Worksheet 2 Contains a table showing the last date and destination...
  16. srizki

    Partial Match to Master list

    I am trying to standardize a list of names of projects, technicians write different names for the same project for example, on one place it says, Forest Creek Wind farm, on another place it is just Forest creek, etc. that causes difficulty using formula. I created a master list of names...
  17. S

    Right with Trailing Spaces

    I am working on a program that will eventually automate the creation of text files and put them in a folder. There is a specific length of the rows, 85 (followed by a 4 line counter), and length of each field. So far most of it has been pretty easy. We have an address (and up to 4 of them)...
  18. R

    REPT Function Lining up Text

    I thought this would be easy, but is proving to be difficult at least for me. I am using the CONCATENATE function to string together names and employee ID's. Both fields are variable length and I would like the ID's to follow the names, but all lined up so easily readable. I thought I could...

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