space

Hi All I am using data validation for a list in column C. I also need to prevent a single space from being entered in column C, so I would like to use code in column C3:C5000 with a message "No space allowed" Thank you in advance!

Hi all Does anybody know the symbol for space when doing a like or am I missing something this does not work If Me.TextBox5.Text Like "*At At*" Then Me.TextBox5.ForeColor = vbRed Else Me.TextBox5.ForeColor = vbBlack End If I also have this below looking for a...

I have a two full columns of data that I need to trim. I can see the extra space at the end, but it's not a simple space from the spacebar. This data is downloaded from an Oracle database which as the source, I have no control over. I used =CODE(RIGHT(V2)) to see what the space is and I get...

I want to check if the value of a cell is written as 100 gram (or a different number) instead of 100gr. Example: 100gr white sugar is wrong 100 gram white sugar is right or 38gr cinnamon is wrong 38 gram cinnamon is right I have tried several formulas but I'm always stuck with the space...

I want to extract text before a comma, or space or if condition 1 or 2 is not met return text in cell: Example: James, John Jones Tom Lily Expected result: James Jones Lily =LEFT(A1,(FIND(" ",A1,1)-1)) extracts text before space =LEFT(A1,(FIND(", ",A1,1)-1)) extracts text before comma...

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

Hello, I need to create or delete rows if the space between two cells isn't the same. I can show an exemple. I need to have 5 rows between each CDS cell, so I need to delete the first row if there are 6, or create 2 rows if there is only 3. How can I do that with a formula or a macro...

Hi, Just wondering if anyone has any experience using Teradata database connections and might be able to give me some advice on how to get around the Spool space issues. I am trying to find a way to potentially join a table before query imports the table to cut down the amount of lines that...

Hi, I have made a code where if I were to write out a name in a textbox the first letter will be capitalized. It also capitalizes the first letter whenever I add a space between names. So, I am having this problem where whenever I put a special character or a number (For ex...

Hello I have a macro that create automatically new Sheets and on each Sheet create a Table The Table Name is based on Sheet Name ActiveSheet.ListObjects.Add(xlSrcRange, Range("A1:G1"), , xlYes).Name = "Tab_" & ActiveSheet.Name Excel replace space and other characters on the Sheet name with...

Can anyone suggest on how to write-protect a PDF generated from excel using VBA? I have been using the following code for almost two years already buy due to security reason, I need to add write-protection to this code. Sub SavePDF() Dim sRange1 As String Dim sRange2 As String Dim sPace As...

I have deployed a Daily Time Record (DTR) system to the field using excel vba. Unfortunately, there are these colleagues who are not so faithful to their work. I have found out that some of them simply edited the PDF generated DTR. Can anyone help me with this? Here are the codes that I have...

The following number is formatted as "GENERAL": 2019-03-06T06:47:06. When I remove the T character and replace it with a space. It changes the number format to "CUSTOM" and now the number looks like this 3/6/2019 6:47:06. What can I do to get keep the number with the "GENERAL" format once I...

I have downloaded a large file on xls format with over 9000 lines. There is one column which contains numbers but the numbers have a space to the right which I am unable to format out so that I can use the column values to make calculations. I continue to get the #VALUE error as the formula...

In a Cell the value stored is 00.00 n the number_format is text. But when i try to replace " . " with space it results in single 0. My requirement is that I should get this 0000 when I replace dot with space Plz help

If there are more than 100 names in an excel, I would like to delete all the spaces between those names at once, is there a quicker way of doing this instead of manually going into each cell and delete the space? For Example: David Beckham --> DavidBeckham Thanks.

hello all, I am currently working on a web site with a description column that cannot exceed 75 char. The data I have exceeds that in certain circumstances. Is there a VBA or formula you all know that will do this: Read cell content from right to left. Stop at the 75th character then cut all...

Hi I have the following formula all over a spreadsheet <colgroup><col></colgroup><tbody> #='Week 1'!I14 #='Week 1'!J14 #='Week 1'!K14 #='Week 1'!L14 </tbody> Is there a macro that will delete the # sign on all cells that have it in and then move the rest of the data back one...

Good day. I have columns of analytical data, some have a leading letter(s) as part of the lab result (i.e., U, UJ, E, B, R), some have no letter. There is a space between the letter and number: U 0.042 I need to reverse the string: 0.042 U If there is no letter (e.g., 0.042 or cell is...

Hi, I currently have a listing of positive and negative numbers (ranging from numbers in the tens to hundreds to thousands to millions) and am looking to have all numbers aligned right excluding the ending ")" for all negative numbers. In other words, would like the alignment of all numbers and...