LinkBack URL
About LinkBacks
If I put columns to alphabetic order, then words are like this
1 st Floor
Aakenkatu
Kauppakatu
Zeppelinintie
Viikingintie
Ysitie
Whats wrong?
If I put columns to alphabetic order, then words are like this
1 st Floor
Aakenkatu
Kauppakatu
Zeppelinintie
Viikingintie
Ysitie
Whats wrong?
Hi,
You have spaces in front of the first 4 words. If they aren't spaces look for a char(160).
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
What means char(160)? I saved this file to CSV(Comma Deliminated) and every word has got "?" front of it?
Originally Posted by MarvinP
Post your excel file, without confidentional information.
I will look at it.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Here it is
and can you als add where you get your problem?
But A column to A to Z and scroll to the last row, there is aslo cells which are starting with A capitalize.
This is the formula in Dutch.
The code had to be expand, but maybe someone else can help us with that.
=ALS(OF(B1={"1";"2";"3";"4";"5";"6";"7";"8";"9";"10";"A";"B"});A1;RECHTS(A1;LENGTE(A1)-1))
The file is to big to upload.
The link to the dutch free site is:
http://www.mijnbestand.nl/share.php?key=6VZBSUIN7K4V
use find/replace ctrl H. copy the 1st character from ang cell, then use ctrl H, paste into "find what", leave "replace with" empty
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks