rept

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

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

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

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)),"...

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

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

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

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

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>

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

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

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

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

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

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

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

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

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