spaces

  1. H

    Remove spaces from 2 cells & join the alphabets

    C5=MAngO123-99 Tomato D5=ITALIAN Forest Trees E5=26 In F5 I want first 26 (E5) digits after removing spaces from C5 & D5 & suffixing D5 with C5 & in UPPER CASE. Answer: MANGO123-99TOMATOITALIANFO. How to accomplish?
  2. S

    Removing spaces from text

    Hello, I am using Excel 2010. I need to remove spaces from a series of numbers but the spaces are in different places. So there are two spaces to remove in row 1, two in row 2, 1 in row three and so on. Is there a single formula that will do this or do I need to run a series of formula...
  3. M

    Removing Extra Spaces At The End Of Range Of Varying Cells

    Once again…… I’m stuck. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I’m trying to find a method of getting rid of unintentional extra space(s) at the end of range of cells (C11: Z –last row of data). I’ve found several discussions on how to...
  4. E

    Using variables in Shell function

    I am trying to invoke a shell function with three challenges - the path to the executable (vlc portable) is variable as it runs from a usb drive causing the drive letter to change; the file names passed to the executable (audio and video media files) are stored in a cell that has a...
  5. D

    Extra space at end of pasted range in text file?

    Is there something inherent in saving as tab delimited text that adds an extra space at the end of the text? My code below works as I want, but the file created as text invariably has an extra space at the end. I know the answer is something incredibly simply, but I'm stumped?! When I...
  6. J

    how to extract away middle initial when the last name contains a space and the cell contains no commas

    Hey all, this formula almost does the job: =IF(FIND(" ",A1&" ")-LEN(A1)-1,LEFT(A1,FIND(" ",A1)+FIND(" ",TRIM( MID(A1,FIND(" ",A1)+1,255))&" ")),LEFT(A1,FIND(" ",A1&" ",FIND(" ",A1&" ")+2))) But as you can see in below example, when the last name contains a space (e.g. Martin Marie Anne...
  7. R

    Recomo Space in a cell

    Hi, i'm doind a download from the internet, and all the cells have a space before and after the number, like "_1234__". How can I remove the spaces and conver the cell in to a number??? Thanks and a good 2011 to all!!! RR
  8. Z

    Separating long sequences of characters by space

    Hello, I have 50 to 100 sequences of 200 letters long or more in a column of Excel. I'm trying to add a space every 10 letters such as: QWERTYUIOPASDFGHJKLZXCVB...etc into QWERTYUIOP ASDFGHJKLZ XCVB...etc Formulas I tried stopped after 10 characters or self-formulas replaced letters by space...
  9. J

    Formula producing unexpected results

    Hey all, I have a formula producing unexpected results. I have a first name, last name, and middle initial in one column: Carlos Alberto Nassimoff Defend The idea is to get Carlos, Albert, and Nassimoff all in their own columns (we can ignore Defend for now, as I would take that out before...
  10. S

    Formula to Delete Blanks in Entry

    Hello, First time poster and I figured out my problem with a VLOOKUP that's been giving me trouble is due to there being a space before some the entries so it's not able to pull it (i.e.00045 vs 00045 [note no space before the first zero in the first one which is what I want]) Is there a way...
  11. M

    Removing spaces at the end of data in cell

    I would like to remove spaces at the end of my data in excel. For example, in cell A1, I have this text. "Motorcycle Market ". I only want the spacing removed at the end of my text and the spaces always vary. In this case their is 15 spaces. How would I achieve this? Any help would be much...
  12. H

    GetOpenFilename error with spaces in file

    I'm not sure why but the following code results in an error when the file you point to includes spaces. It works fine otherwise. Any thoughts? I'm thinking maybe I can replace the spaces with nil? Filename = Application.GetOpenFilename("Adobe PDF (*.pdf),*.pdf") destinLOC =...
  13. R

    Unwanted spaces

    Greetings, I extract info from another system into a spreadsheet and one column will have a date (MM/YYYY). When sorting, It would put everything in month order not chronological order. This is because the other system places a space on the ends of the text string. (_MM/YYYY_) I can't replace...
  14. J

    Dlookup and treatment of "space" in Access names

    Hi, I have a specific question and a general question. The specific question is this: I currently have a form with two comboboxes called "Combo Case Code" and "Combo Case Name." I've linked the values to a query that retrieves values for fields called "Case Code" and "Case Name" in a table...

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