spaces

I need 5 spaces after the 4" part of the formula. The formula is working except for not having the spacing =IF(K11=0,I11 & "$"&TEXT(AH11,".00")&"/Qty",AH11&"/lf")

Hi, Didn't know how to word the title, I have data in the following format: 00100 | A1A 00101 | 00102 | B6A 00103 | B9H 00302 | A7R 00403 00404 00309 | B8R 00408 | E7S I need an helper column (C) to fill down the B column values Example: 00101 = A1A 00403 and 00404 = A7R There is sometimes...

I have written code to remove/trim the trailing spaces in Col A & B on sheet 2 Eg BR1 Shirt Sales in this eg remove space/s only after sales The macro trims the data in Col A , but not in Col B It would be appreciated if someone could kindly assist me Sub TrimtrailingSpaces()...

Good day I am working in a system where i extract information from. When I do the extraction i get it in the below format wen is paste it into excel (Offce 365) <colgroup><col width="74" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;"> <tbody> Value...

Hello, I have been searching the internet for sometime nowand cannot find solutions to my problems. I have the code below which generatesand email for me which works great! But I am just perhaps being picky about acouple items and hoping maybe someone can provide a solution to them...

hello I have some external data that I import daily into a spreadsheet using VBA. The data I am given is not consistent - there are often spaces in the string in data in column 'I', and I would like to clean it up before importing. The spacing is also never consistent so I would like to make...

I have several VBA macros which i hopeful of adding only a 'delete leading and trailing spaces' to. i apply the macro to different size files, with different row and column lengths. What i'm after is a code that will apply specifically a 'delete leading and trailing spaces' to what i...

I have a macro that formats a set of data. Part of it is that I this line: ActiveCell.FormulaR1C1 = "=MID(B4,FIND(" - ",B4)+1,LEN(B4))" The problem is, I don't want a space before and after the hyphen. When I take it out and save, it puts the spaces back in and it's driving me insane. How can...

I have a TextBox on a UserForm that displays the results of calculations done inside the UserForm's code. I build up a string using the concatenate operator along with spaces (" ") and the values. When all calculations are finished, I print a report similar to the following: input output...

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

Hi, everyone I'm writing a code to copy tables from EXCEL to WORD,and in WORD the code can adjust table's columnswidth. I find an interesting thing in this process, that is when a table copies from EXCEL to WORD, it shows a lot of spaces in it's cells where the cell has number, but when the...

I have a script that searches phone numbers Set rngFind = .Find(What:=Trim(txtLookup.Text), LookIn:=xlValues, LookAt:=xlPart) Some of the numbers have spaces and some are just numbers. eg in the database a phone number may show up as "0218888888" or "021 888 888" Is there a way so when my...

I am using this script in a macro and it runs fine but if it runs a second time and nothing has changed it geves me an error. How can I protect against that? ' pad Spaces ActiveSheet.UsedRange.SpecialCells(xlBlanks).Value = " " <strike></strike>

Hi, I'm helping a friend with a mass of text data that has been imported into Excel. The data is textual, consisting of bold text followed by unbolded, and forum help has shown me how to split bold from unbold. However, it now seems there are issues with the imported data, namely leading and...

Hi, I have some code from this site that removes leading spaces from most cells in my data, but not all. What sort of thing could cause these 'unknown' spaces and how do i deal with them please ? Here's the code: Sub RemoveLeadingTrailingSpaces() ' hiker95, 02/26/2016, ME9242394 With...

Good day guys and girls I have an issue and need to find a way to resolve it there is a column that has an amount and in that field, the number has 6 spaces and cant removed with formula I have to do it manually $ 1,632.00 I try to replace, =substittute(h2," ","")...

See link for the file:https://www.dropbox.com/s/ta2yfrvgorw334v/VBA%20dynamic%20array.xlsm?dl=0 There is VBA code for dynamic dropdown in sheet "Entry", you can test it out and see how it works. I have two issues with it which I can't resolve: 1)The drilldown has empty spaces when you drill...

Have a column C with a lot of data. Many of the cells contain spaces in the end. I want to trim each cell by using a macro looping through each cell. I want to practice looping. Is it possible to write a code which loops through each cell and removes the space(s) in each cell. Thanks.

Hi, I am new to VBA and trying to get to grips with it. I have a large list of phone numbers that are in different formats i.e. 01234 456 789, or 01234 456789 ect. I have managed to clear all spaces out to leave continuous numbers, now I want to insert a space after 5th digit of the area code...

How do I remove the spaces before the numbers and after in excel. I tried find and replace and it does not work. I also tried trim still no use. <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> 300.00 440.00 1,694.11 2,909.54 5,400.00...