space

I have this =IFERROR(SUM(--LEFT(AP32,(FIND("h",AP32,1)-1))*60)+VALUE(MID(AP32,SEARCH("h",AP32)+1,SEARCH("m",AP32)-SEARCH("h",AP32)-1)),"") which turns 9h0m into countable minutes bright sparks at work have then adopted 8hr37m as a new way of writing without mucking up the original...

I am using a VBA to auto fit the widest entry for a range of columns. I am wondering if there is a way to add some space to the auto fit so the columns are not so tight to the text. If some one could lay out the format I would appreciate it.

So here is my dilemma and it is driving me nuts. Starting Cell possibilities: "FM. Porter Jr. INACT " "FM. Porter Jr. GTD " "FM. Porter Jr. OUT " Desired Output: "M. Porter Jr." There is a space before and after "INACT"/"GTD"/"OUT". Some have "Jr." or "III" or nothing after the name. My...

Hi everyone, I'm sure this is simple but I can't find the solution online. Is there a way I can use a MID formula like this that follows this, unless there is a space, in which case it stops earlier? I have text, for example: <tbody> Tue, Jul 31 09:38:21 BST 2018 and Tue, Mar 6 14:26:37...

Hi all. i have this formula COUNTIFS(Rec1!$D$4:$R$4,"<>",Rec1!D6:R6,"") to count blanks. now it stop working after i import data by paste value into that range. by paste value, empty space become "0". before i manually input data and leave space empty if zero. how should i amend this formula...

Hey Folks, Newbie to the community here, trying to update weekly football scores that i copy and paste from a website. (covers.com) The football scores come in this format W/L (win or loss) and the score with a hyphen in the middle. "L 31-33" would be a loss as the team scored 31 points and...

I hope that this is not too dopey a question. I have a column containing a variation of UK postcodes where there can be 1 or 2 letters and 2 numbers grouped together like DE74 or E7 followed by a space and a further digit like DE74 2 and E7 9 but I am having trouble searching specifically for E7...

I have a dashboard that I would like to add some customer detail to but I don't want to take up to much space. If i do a top 20 a lot of meaningful customers are left out. Is there any way to lock the size of a pivot table at 20 rows but include a scroll option so that all customers can be...

Hi Everyone, Ok so please help with this formula if you can? I have names in column B I need to change the way they are recorded for our new system. In colunm "B" I have names that are all set up as either sir name and first name or sirname and initial. I need to reove the space between...

is there a way I can replace the use of a tab with just a single space bar? I dumped down a ton of data that separates names and numbers using a tab instead of just a single space. I tried the find replace function putting in five spaces with one space but that doesn't work

I use a handy process from Rob Collie's site to find item descriptions that contain certain text. However, the problem is that Power Query strips trailing spaces from my search values. So if I search for "rat " with a space I get "laboratory", "calibrator", and other variations because PQ has...

how could I extract to 3 columns the following string format? DATE SAMPLE OF STRING AMOUNT first text is before the first occurrence of the space 2nd text is between the 1st space and the last space 3rd text is after the last space say string is at A2 B2 = DATE C2 = SAMPLE OF STRING (can...

Can power query take a list of 24 values in a column and move the values 10 cells apart in the same or a seperate column?

Dear Friends, I have a few rows & columns in a sheet where some cells contains the content from other sheet also. When I copy these content, and paste it in notepad, it gets pasted with a space of a "Tab" where as I want a simple & single space. someplace I want it after the word / number in a...

hi all members, which formula make space after cama, column in the left is original data, and the colomn in the right is what i want to do <tbody> 123,325,551,555,525,875,219,7514 123, 325, 551, 555, 525, 875, 219, 7514 123,325,551,555,525,875,219,7514 123, 325, 551, 555, 525, 875, 219...

Hi all, I have the following macro but stuck with adding an edit to it Sub RoundedRectangle5_Click()HondaParts.MyPartNumber.Value = ActiveCell.Value HondaParts.Show End Sub When the macro runs i would like the value in the cell to be forced to upper case,value will be Numbers & Letters. I...

HI guys, I am struggling to get the function to work to find me the position of the 4th last space within a string from the right. String is like.. "Firstname Secondname Surname Myhome 23 8545 Westfield" but it also could be like "Firstname Surname Myhome 5 4524 Testinghof" Now I like to get...

Hi All, I have messed about with this for hours with zero progress so I'm going to open this up to the room in hopes somebody can be a lifesaver. I've taken on a project of updating IP ranges. I have close to about 2 million of these to work through and our system has generated the IP's in a...

I am trying to do a vlookup however the text in A1 has a space at the end of it whereas the vlookup text does not. Is there a formula to get rid of the space at the end of the text in A1 that I could write into B1? Thanks!!

Hi everyone, I have seen this on a Mr Excel video but cannot find it. I have a table of data with names in each cell, the problem is that sometimes the name is R Rabbit and other times it is R Rabbit with a space behind the T. Excel now treats this as two differant strings. How can I remove any...