spaces

  1. P

    Adding Spaces into Text

    Hi everyone! I used a concatenate formula to combine a set of address columns into a full address column. My only issue is that the spaces were not added between words. Can you help me do this? Currently all the addresses look like this: <tbody> 000 Peach StreetDentonTX76209 How can I...
  2. R

    Add multiple spaces in a cell

    I hope someone can assist with what seems a simple formula that I have failed to grasp. In the example below I would like to add spaces before a value in a cell depending upon the value in another cell. Example: Column A - Text Monday Tuesday Wednesday Column B - Number of Spaces 2 4 6...
  3. P

    Removing all Spaces

    Hi All, I have 1 column with a series of numbers that has 6 digits then 2 spaces and then 4 to 5 digits. i am trying to remove both spaces. I am able to remove 1 space with TRIM but I need to remove the 2nd space. My co-worker has a concatenate that has no spaces and can't add spaces to their...
  4. I

    ADD SPACES via FORMULA: baced on a number in adjacent cell

    I need to add a certain number of spaces based on a number in an adjacent cell. Am concatenating several cells into one, and using Courier New font to line things up, but need to add a number of spaces to the end of the next to last concatenation based on number in an adjacent cell.
  5. J

    VBA Spacing between two words

    Hi everyone, I've been trying the whole day but can't figure it out. I need to align words in two rows. (It's used in an automatic header.) What I've stumbled upon was that adding spaces doesn't automaticly mean words align perfectly. What is want to accomplish is something like this. <tbody>...
  6. B

    replace Blank Spaces in text string by inserting a comma where there are 2 or more spaces.

    I have many cells with text strings that may contain 2, or more, blank spaces within that cells text. (I don't care about a blank space of 1). each cell may contain multiple instances of these blank spaces. There is no order to the blank spaces, so i need to find the blank spaces and insert a...
  7. J

    adding spaces in front of text and "alt enter:" tabs in one cell (address)

    I have an address that is in one cell formatted with: Name address address2 city state zip There is a hard tab (alt tenter) between the lines after the first line. (the bolded lines) I need to keep everything in one cell, and add five spaces in front of each line. I need to be able to do this...
  8. muhammad susanto

    Insert 3 Spaces Between Number

    hi all... how to make 3 spaces between number below : count of number = 18 <tbody> Data After formula 197906141999031001 19790614 199903 1 001 196206031981091002 19620603 198109 1 002 </tbody> anybody help me, thanks a lot.. .sst
  9. C

    Trim column in table databodyrange?

    So as discovered earlier I have an issue with extra spaces when I bring in data from another souce file. What I want is to be able to, using VBA script, trim all extra spaces, specifically after the text. My data is in a table titled "PasteTable" I have tried every solution I can think of...
  10. Jeffrey Mahoney

    Padding Number Format with Spaces

    Is there a number format or conditional formatting that can pad any alphanumeric value with spaces? I create a lot of Excel Forms. I want the empty cell to display as underline and I want the underline to show the full width of the cell. I know I can put spaces in the cell and it will show...
  11. P

    remove duplicates and also left out blank rows formula

    Hello, Is there a way to make this formula a bit more efficient? I'm trying to remove duplicates and remove blanks, but not sure how to do it. I have this basic formula which removes duplicates, but it leaves blank spaces, I think there's a way using IFFERROR, INDEX and ROW. Here is a simple...
  12. T

    File location with spaces

    I am creating the body of an e-mail with some file location. This code works if Fileloc does not have spaces: HTMLBody = "Hello ..<br />next line ..." & _ "Click <a href=" & Fileloc & ">" & "some location" & "</a> to ..." How can I amend it to take into account...
  13. J

    Not quite an average...

    <tbody> Veh Type Sun Mon Tues Wed Thu Fri Sat Total 1 2 2 2 2 2 2 2 2 1 1 2 2 2 2 2 3 2 2 2 1 1 1 1 </tbody> Can anyone advise on how I could automate the below calc, we do manually at the moment but there is probably and easy formula I am...
  14. K

    This formula works I need some 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")
  15. J

    Formula to group values based on above cell?

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

    Macro to trim trailing Spaces in Col A & B

    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()...
  17. Wimpie

    Text to Value

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

    HTML email

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

    trim then add space

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

    add Trim to VBA code within a macro

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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top