spaces

Hi Lets say I have this text: AAAA BBBB CC DDD EEEE Is there anyway I can return the location of the spaces (5,10,13,17) in this text? or do I have to nested Search() to find it for me? Thank you.

Hey Everyone! I created a macro a few months ago that help us to make some reports easier to input. There are multiple lines in these responses that we don't need and the only way to find the ones we do need I used the following method. All of the cells that we needed started with a number, had...

Can someone show me how to remove all words, characters and extra spaces from a Userform textbox with the exception of the first word?

Hi All, New to the group and I have a problem that is probably very simple but it has me stumped. I have a list of names produced by some calculations. This list has spaces in it where the results mean that the name is not required (like a staff required list) I want to be able to use the list...

What is the excel formula to be used in the following strings? I need to remove spaces and commas, etc. Ex. CC1994, 2 - it should be CC19942

So, our payroll system doesn't know how to properly space text in a report to be exactly how long the word or words are therefore we have to estimate the spacing to be x number of spaces. Which means if the word or words are shorter than x number, the rest of the field contains spaces. For...

I am working on a very large genealogy project. I need to be able to extract date, first name of person and parents name. the data will appear like this (Very consistent spaces) in A2: January 2 Joey Joseph Schmoe (Joe & Josephine). I would like 3 separate cells. B2:"January 2", C2:"Joey", D2...

please help i have excel file i want to convert it to text files with a specific spaces between columns thanx

Hi Friends, I want to remove all spaces from first row. How can I do that with a macro ?

I need a quick fix for an issue I've been having. Basically I have a data base, and I send versions to people to populate. However, in the excel sheet that I have sent, people have been inserting multiple spaces, in place of a line break. I need to remove these spaces and replace them with a...

In the worksheet I have fixed the column width as follow: Column A Column B Column C AAAAAAA|BBBBBBBB|CCCCCCC| Supposed when I save it as prn the output would be: AAAAAAABBBBBBBBCCCCCCC However the output went wrong and become: AAAAAAA BBBBBBBB CCCCCCC There are three extra spaces between...

The ever-awesome PowerPivotPro gurus posted a thread on how to do a CONTAINS search from a measure selection. The list to use in the slicer is generated by a query as shown in a simplified sample below. The problem is that PowerQuery appears to eliminate spaces from the list in this query...

I'm using 'Chr(10)' to add line spaces between text in a textbox, (not sure if this is the best one to use and don't know the difference between the different methods anyway), but is there a way I can run a routine to remove extra spaces once the Userform is displayed, or just before it is to...

I have a strings of data that often look whats below, I can isolate the first segment and the last segment...but I can't get the middle segments. The number of spaces can vary and it's turning out to be a nightmare. Forums/Google haven't yielded results (I may be looking for the wrong thing)...

- I have a Userform that contains a Textbox where an applicant enters their first name - Some applicants use two names in their first name with no hyphen (e.g. "Rose Ann") Question - I want the textbox to kick out spaces prior and following the name - I also want to remove double or more spaces...

Hello, I know of the ISBLANK feature, but that only works if a cell is truly empty (nothing in the cell and no space characters). Is there a function that would do this? Alternatively, is there a way to remove all spaces from an empty cell? Thanks, Andy

Hi I have been trying, unsuccessfully, to remove trailing spaces from a set of numbers (all are 10 Characters) whilst keeping any spaces that may exist in the middle. TRIM does not work because some of the numbers have 2 spaces in the middle and the TRIM function removes one of these. I would be...

I have leading and trailing spaces either side of values. I'm getting rid of said trailing/leading spaces with =TRIM(CLEAN(A1)). The problem is some of the spaces are "different/special" spaces, (I don't know what type, just that they are different). When I use this =CODE(LEFT(A1,1)) I don't...

Here is my formula =IF(LEFT(A1,13)="Game# 1 MSSP ",'M-Super-Pot(1)'!$E9&$AB2,"") Right now $E9 value & $AB2 Value are crunched together want to add a few spaces in between them. How can I code this up? Hmm another & before the last one but &" "$AB2? Not sure how to code it up :-( thanks...

I have a spreadsheet that contains text strings in Dutch. I'm trying to single out all the rows that contain either the Dutch words "u" or "uw." Both words will have a trailing space, a leading space or both, depending on where they occur in the text string. Is there a way to filter for these...