spaces

  1. G

    Replace 2 or more spaces with text

    Hello, I have : Serial Name Composition Data for HTML 1 Destadine Syrup Each ml contains: Desratadine BP …….. 0.5 In a flavoured syrup base FORMULA (Thanks to @Fluff) ="<tr><td>"&TEXTJOIN("</td><td>",,SUBSTITUTE(LEFT(A2:C2,LEN(A2:C2)-1),CHAR(10),"<br>"))&"</td></tr" Results =...
  2. L

    delete empty space

    Hello! I have a column with many names, the problem is that there is an empty space before and after the name. It will take me a while to delete it manually. Is there a way to get rid of those spaces? " Lavinia Drtcxc " " Mara Fort Dguyutf " . . So one space before and one after. Any ideas...
  3. R

    Remove Text String from Text String

    1 need 00001 help please-__- need help please-__- KXY247 with KXY247 this with this 35 major 35 brain fart major brain fart Column A is showing a string of what I need removed from Column B with the final result being Column C. I have about 33000 rows this needs to run on :) wish me luck...
  4. DRSteele

    Split text cell into columns of words.

    If you have a cell containing a text string with spaces in it and you want to split it by spaces into columns, you can easily do so by using the Text-to-Columns functionality. Or you can use Power Query to clean up and split everything. Or if you want to use formulas, this algorithm can help...
  5. B

    Adding spaces in IF formula

    I am needing to add a few spaces between E3 and J3. Could someone help me modify the formula below. =IF(E3="","",IF(C$3<>"",C$3&"","")&F3&" Rev "&E3)&J3 Thanks for the help
  6. B

    Text to Columns on Two, or more, blank spaces?

    In Cell A1 I have a Huge Text String that originated in a .pdf file. There are no useful delimiters, such as commas or semi-colons. any text that has two or more spaces between is a field in the original .pdf is there a way to split this out is by using two or more blank spaces as the delimiter?
  7. S

    spaces after figures

    Hi, I received 1 excel file contained values but having 2 or 3 spaces after figures, I think this is formatting issue, what formula can I apply to get figures only. In the below example x means space Current figures 100xx 300xxx 210x Wanted 100 300 210
  8. T

    Deleting spaces from blank cell in sheet?

    Hi Everyone. I need a macro that can help me clean up my data range. We export data from our CRM system which is very old and the data needs sorting out before i can do anything with it. I've done most of the macros but am stuck and looking for help. I need a macro to help me empty out cells...
  9. M

    SUMPRODUCT excluding blank cells

    I'm trying to count how many agents hit goal in a particular quarter. I've set up the following formula to see if the number in column B is greater than that in column H, subtracting if LOA is entered. My problem is it's counting blank spaces, totally throwing off my calculations, and I can't...
  10. Z

    Spaces in a searchable dropdown

    I have made a drop down list that is searchable using formulas and it works. However if i type in 2x4 it gives me certain items. If i type in 2 x 4 with spaces it gives me different items. =IFERROR(VLOOKUP(ROWS($I$2:I2),$C$2:$D$3799,2,0),"") this one looks to see if there is text from what is...
  11. U

    The opposite: Delimited to formatted text

    Hello, Text to Delimited text seems to be common, but not the other way around. I have an excel table with thousands of rows, all neatly organized in a rational manner. all cells are used with no spaces. i need to output data into a text file for another computer program's input. It needs to...
  12. J

    Create new tab with a template, locking old one when completed

    Hi All, I am attempting to create an archiving system for work and having some trouble finding a way to do a certain thing because I'm not sure how to word it for the searches... So, we have an archiving system, which is a 9 x 9 box for samples (81 samples); on the worksheet so far i have a...
  13. S

    Spaces don't look like spaces?

    Hello, I am putting together a string, and using the print statement to output to a file. I have an equation in the cell that I want to print out. The equation results in a string. That string has general characters, and spaces in it, and looks fine in excel. I use the following to print to...
  14. B

    Spaces spaces and more spaces

    Hello all, I have a text file that gets imported into excel that is + separated. Most of the columns have many spaces at the end of them. I can't use the space separator during the import because it will break up areas of descriptions. I would love to hear your thoughts on how I can get rid of...
  15. S

    Spaces causing error

    Hi guys, Would appreciate any advice on the following please. The formula below is functioning reasonably well except for spaces occurring a the end of each returned result. =VLOOKUP([@Column2],'list of part numbers'!A:C,3,FALSE) I have to "Find and Replace" the spaces for the data to show...
  16. A

    VBA to assign car parking spaces

    Hi, I'm pretty new to VBA, and was hoping someone might be able to help me with something i am trying to write: Sheet 1 (input tab): Row 1 contains Mon-Fri, with the rows below detailing what car parking spaces are available for those days, for example, if space 18 is available on monday...
  17. S

    How to add spaces to the both sides of text in a cell

    I need to add spaces in the beginning and end of a text. e.g Text is John. I need 4 spaces before J and 7 spaces after n. How to accomplish this.
  18. R

    Need Excel Formula to trim spaces before Numbers

    Hi there, Please provide excel formula to trim spaces before numbers, i have received large data that contains spaces in each cell before the amount. I am using MS Office 2010. Thanks, Raaj.
  19. M

    warehouse racking file

    Hi All. I have just been sorting out an excel file for the warehouse locations for pallet spaces. What I was trying to do was if a was in a space I could either use an EU for euro pallet or UK for a UK pallet which are bigger than the Euro pallet it would turn Red to say there was a pallet there...
  20. F

    Remove leading spaces from text pasted in Texform of Userform

    Hello to all, I have a Userform with a TextBox and I need to paste to some multiline text from clipboard. The issue is that text I need to paste it has lines with many leading spaces for some lines and I want to remove those leading spaces (and trailing if there are) automatically when I paste...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top