spaces

Hello, I got rid of subtotals in this pivot table, but how can I get those hierarchy titles and empty spaces to go away?

Hi all, I have a code that adds in n number of new worksheets and names it based on cell value. Eventually, I have a summary sheet that will perform lookups to respective sheets using indirect. The newly created sheet names do not have any spaces in them, but for some reason the references...

Hi I am trying to match all white spaces in a sentence, except for those after either a match on a particular word, or that particular word followed by another particular word. I'm trying to use either lookahead or lookbehind. I can match the space immediately preceding the particular word...

Hi All, My data is supposed to look a certain way ( see below) I need to remove spaces between D, the ID # (for example DXH110817) and the last name Doe. I'm trying to find an efficient fast way of doing this since I have about 50 records in my data. Any suggestions? So right now, it...

I am trying to figure out some way to take a string and make sure its a certain number of characters (I would say width but that would be much more involved given characters and point sizes are so confusing!!!) and center it via spaces. For instance, if I have a string "cat" but I want it to...

Hello, I am trying to create a macro that will remove spaces from a column, IF it starts with "3 464 xxx xxx". Our vendor has spaces in their part numbers, but our system does not use them. Externally, we have to keep the spaces, but for internal use I need to remove those spaces. I have...

Hi all, I'm trying to use this argument (arg): 'T:\SUPERVISOR REPORTS\2018\[May 2018.xlsx]10-D!R7C2 like this: GetValue = ExecuteExcel4Macro(arg) BTW, arg is created like this: arg = "'" & path & "[" & file & "]" & sheet & "!" & Range(ref).Range("A1").Address(, , xlR1C1) (it was found...

Is it possible to select a range of cells and run a macro. The macro should remove 2 spaces entered in the end of each selected cell.

I am doing some data comparison/testing and need a way to remove trailing spaces from the end of each cell. The number of spaces at the end could vary depending on the data. Clean/TRIM is removing spaces in the middle that I must retain. I have also trying using SUBSTITUTE to replace but again...

Hi there, I have copied a dataset from word to excel but now excel does not recognize the amounts as numbers so I cant do any calculations. The numbers appear as 3 258 124. I've tried to remove the spaces but excel cant find any spaces so it must be a special character. Please help. Thanks...

Hello all, I want to add spaces between the characters in the string. The macro should add space between each character.If already space is exist it should ignore and add only where space is required. The string is in last used row of H column. Thank you.

Hello all, i want to remove more than one space between the contents in the string. The string is always in the last used cell of H column. The string contains both single and double spaces. The macro should delete the double space alone and leave the single space as it is. Please heads up...

Hey everyone! Was wondering if there was a way to get Application.ThisWorkbook.FullName to display spaces as %20? I am having an outlook email pop up and in the body it is making a link to the file. If the file has spaces in it though the link ceases to work correctly. I've read if you use %20...

Hello There, I'm learning a lot about VBA but I have a quick question. If a macro can be performed more than once on a given cell, will it be performed as many times as the rules which govern it allow? Or will it only make that initial run through and then have to be run again to get the rest...

I have a list of amount but it contained spaces before and after figures how can I get only numerical value. like 100,000 78,900 23,000

I have a CSV that is received from another department that I pull into my workbook. One cell contains fractions and the inch mark followed by 17-24 spaces. I'm trying to pull from that cell to indicate what file I need to look in for the information and I'm not sure how the pull the...

I saw Rick Rothstein's code that removed Non-Printable Characters, and did a Clean and trim as well. Can it be modified to leave spaces in the middle alone? such as, if I have a column of names that may have leading or trailing spaces, or both...Like so: Alfred E. Newman John Paul Jones I'd...

I have a VBA script in an excel file that will generate an email. My problem is setting the font in the email. This code works: strbody = "****** style=font-size:11pt;font-family:Arial>Hello.</BODY>" This code does not work: strbody = "****** style=font-size:11pt;font-family:Segoe UI...

Hi, I am struggling with Power Query in Excel. I am trying to create a function to use in the spreadsheet. My spreadsheet contains column headers with spaces in and therefore my query contains the same. The problem seems to be that my query has spaces in there - if I change (Product name)...

I am using vba to search for searching for certain key words/phrases in excel spreadsheets. Sometimes a phrase may have extra spaces in between words i.e. "Forecast O&A $ per Unit" When I search i use "Forecast O&A $ per Unit" (only one space between each word). In my spreadsheet...