I have a list of street addresses. I want to alphabetize them. I just want to remove all the text (usually just numbers but not always) up to and including the first space only.
Thanks in advance
I have a list of street addresses. I want to alphabetize them. I just want to remove all the text (usually just numbers but not always) up to and including the first space only.
Thanks in advance
Last edited by rickshadey; 10-23-2008 at 08:52 PM.
Hello,
Give text to columns a try,
select the column with the data and then goto=>data=>text to columns
select the delimited option then next, then select spaces then next and then finish
Hi there,
Assuming your data starts at cell A2 (change as required) the following formula will do the job - just fill down as required:
=TRIM(MID(A2,SEARCH(" ",A2),255))
If this is to be the end result, you can convert all these formulas to values and then delete Column A (in this example).
HTH
Robert
Tried that. The problem is that it breaks up ALL spaces. I don't see an option to make it do only 1.
45 Main St gives me three columns
23 State Line Rd gives me 4
I only want 2. Everything left of the first space. I would've swore i saw someone do this before...
Am I doing something wrong? I pasted the formula in and i get a warning saying its a circular argument.
still not getting it. I see what you mean with fixed width, but there are too many different lengths of street numbers.
OK! You were right on! Thanks...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks