• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hidden items?

Christina Calkins

Christina Calkins

Member
Hello, I hope that my worksheet uploaded. I am having difficulties with an Excel spreadsheet. I always sort this by Destination City/st, then Origin city/st. Just recently when I sort it, the Origin cities are not in the correct order. What shoudl I be looking at/for?

Thank you,
Christina
 
Hi, Christina Calkins!
You don't want me to tell you that it didn't, do you? Had read your post you should have arrived at the same conclusion.
There are 2 main reasons for the internal upload failure:
- files greater than 1Mb
- file name longer than 100 chars
If any of these, please use a cloud service like DropBox.
Regards!
 
Well, that's just my luck. The file is 11 kb and the file name is working copy. I have never worked with cloud service DropBox, so I am new to it.
 
Hi, Cristina Calkins!

Try this:
a) Surf to https://www.dropbox.com/
b) Click on Download
c) Save the file in any place where you can easily find it
d) Run it and follow the steps (registration, etc.)
e) You should end with a folder DropBox and many subfolders (Public among them) usually under Users/YourUserName
f) Copy, don't move, the file you want to upload to Public
g) Right button from the file explorer, Share Public Link (it gets copied in the clipboard)
h) Come back here and paste it.

Regards!
 
Hi, Christina Calkins!

The worksheet "says" that the data is sorted by ST (F), City (E), ST (C), City (B), you could check it easly removing and setting again the option My Data Has Headers, but I'm somehow reluctant to agree with this. Let me see.

Give a look at the uploaded file. I added 4 columns, G:H have the length of columns B:C cells contents and K:J those of E:F. Check this and edit manually any "strange" cell (F17) with F2, and you'll find that it has trailing spaces. Remove them and retry.

If you have a lot of data, you can write at any blank column:
=TRIM(B2)
same for C, E, F, then copy down as required, and then select by pairs of columns, and copy & paste values over the original cells.

Regards!
 

Attachments

It worked, not that I was expecting it not to. One more question. Since I have different colors on that spread sheet, is it possible to do the =TRIM() and not have it copy the same color all of the way down? I want the column that the TRIM is in to be exactly like the column that I am trimming. Does that make sense?
 
SirJB7 said:
If you have a lot of data, you can write at any blank column:
=TRIM(B2)
same for C, E, F, then copy down as required, and then select by pairs of columns, and copy & paste values over the original cells.
Click to expand...
Hi, Christina Walkins!
This should keep your original format (color, bold, etc.), doesn't it?
Why do you say it didn't work?
Regards!
 
Hi, Christina Walkins!
Glad you solved it. Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.
Regards!
 
You must log in or register to reply here.
Back
Top