Excel Question
Moderators: Bakhtosh, EvilHomer3k
- Grifman
- Posts: 21280
- Joined: Wed Oct 13, 2004 7:17 pm
Excel Question
I have 4 letters in a cell, AAAA and I want to add 9 periods to the end of that text so I used:
=(cell with AAAA)&"........."
This gives me AAAA......... in my cell with the formula
However, if I use LEN(this cell) it says I have only 8 characters. But I should have 13, the AAAA plus my 9 periods. Why isn't it giving me a length of 13? If it backspace to take the periods out, it takes out 3 at a time rather than one at a time. It seems like Excel isn't counting each period as one character which is what I want. Anyway to fix this?
=(cell with AAAA)&"........."
This gives me AAAA......... in my cell with the formula
However, if I use LEN(this cell) it says I have only 8 characters. But I should have 13, the AAAA plus my 9 periods. Why isn't it giving me a length of 13? If it backspace to take the periods out, it takes out 3 at a time rather than one at a time. It seems like Excel isn't counting each period as one character which is what I want. Anyway to fix this?
Tolerance is the virtue of the man without convictions. – G.K. Chesterton
- stessier
- Posts: 29840
- Joined: Tue Dec 21, 2004 12:30 pm
- Location: SC
Re: Excel Question
I think it is counting them as ellipses, which is kind of funny (because it is not happening to me).
Have you tried
=(cell with AAAA)&"."&"."&"."&"."&"."&"."&"."&"."&"."
Edit: Tried it in Excel 2013 and my solution works.
Have you tried
=(cell with AAAA)&"."&"."&"."&"."&"."&"."&"."&"."&"."
Edit: Tried it in Excel 2013 and my solution works.
I require a reminder as to why raining arcane destruction is not an appropriate response to all of life's indignities. - Vaarsuvius
Global Steam Wishmaslist Tracking
Global Steam Wishmaslist Tracking
Running__ | __2014: 1300.55 miles__ | __2015: 2036.13 miles__ | __2016: 1012.75 miles__ | __2017: 1105.82 miles__ | __2018: 1318.91 miles | __2019: 2000.00 miles |
- Grifman
- Posts: 21280
- Joined: Wed Oct 13, 2004 7:17 pm
Re: Excel Question
Thanks, that's good idea, I'll try that.stessier wrote:I think it is counting them as ellipses, which is kind of funny (because it is not happening to me).
Have you tried
=(cell with AAAA)&"."&"."&"."&"."&"."&"."&"."&"."&"."
Edit: Tried it in Excel 2013 and my solution works.
Tolerance is the virtue of the man without convictions. – G.K. Chesterton
- Montag
- Posts: 2814
- Joined: Wed Nov 03, 2004 2:14 pm
- Location: Indianapolis
- jimbo
- Posts: 372
- Joined: Wed Oct 13, 2004 9:21 am
- Location: you don't need to know my location
Re: Excel Question
You could also remove the entry in your autocorrect settings for changing ... into ... (three periods into ellipsis)... probably.
- stessier
- Posts: 29840
- Joined: Tue Dec 21, 2004 12:30 pm
- Location: SC
Re: Excel Question
The & function is the same thing and uses less keystrokes than using concatenate (in this case anyway).Montag wrote:you can use the concatenate function as well
I require a reminder as to why raining arcane destruction is not an appropriate response to all of life's indignities. - Vaarsuvius
Global Steam Wishmaslist Tracking
Global Steam Wishmaslist Tracking
Running__ | __2014: 1300.55 miles__ | __2015: 2036.13 miles__ | __2016: 1012.75 miles__ | __2017: 1105.82 miles__ | __2018: 1318.91 miles | __2019: 2000.00 miles |
- Isgrimnur
- Posts: 82296
- Joined: Sun Oct 15, 2006 12:29 am
- Location: Chookity pok
- Contact:
- Kraken
- Posts: 43790
- Joined: Tue Oct 12, 2004 11:59 pm
- Location: The Hub of the Universe
- Contact:
Re: Excel Question
Here's a weird one for you.
Wife's Win 10 laptop running Excel from Office 2007. When she double-clicks any Excel file, the program launches, but the file does not load. Choosing "Open" from the file button opens it without problems. AFAIK this behavior only affects Excel -- Word docs behave as expected when double-clicked.
Wife's Win 10 laptop running Excel from Office 2007. When she double-clicks any Excel file, the program launches, but the file does not load. Choosing "Open" from the file button opens it without problems. AFAIK this behavior only affects Excel -- Word docs behave as expected when double-clicked.
- gilraen
- Posts: 4321
- Joined: Wed Sep 04, 2013 7:45 pm
- Location: Broomfield, CO
- Kraken
- Posts: 43790
- Joined: Tue Oct 12, 2004 11:59 pm
- Location: The Hub of the Universe
- Contact:
Re: Excel Question
Thanks, I'll have a look at that. I figured it's some obscure setting because everything is working fine otherwise.
- MonkeyFinger
- Posts: 3223
- Joined: Thu Dec 30, 2004 10:23 pm
- Location: South of Denver, CO
Re: Excel Question
Be curious if that works for you. I've got something similar with a work Windows 10 laptop and Excel in Office 2013 - sometimes a pinned file will open as a blank workbook. Thankfully it's pretty rare but still a bit of a head scratcher when it happens.
-mf
- Kraken
- Posts: 43790
- Joined: Tue Oct 12, 2004 11:59 pm
- Location: The Hub of the Universe
- Contact:
Re: Excel Question
It might be a few days before Wife's laptop is both home and not in use, and I remember to try it. But I will get to it eventually and will post my results.MonkeyFinger wrote: ↑Wed Apr 04, 2018 8:59 am Be curious if that works for you. I've got something similar with a work Windows 10 laptop and Excel in Office 2013 - sometimes a pinned file will open as a blank workbook. Thankfully it's pretty rare but still a bit of a head scratcher when it happens.
- Kraken
- Posts: 43790
- Joined: Tue Oct 12, 2004 11:59 pm
- Location: The Hub of the Universe
- Contact:
Re: Excel Question
The box was indeed checked, and unchecking it did indeed fix the problem. Thanks!
- MonkeyFinger
- Posts: 3223
- Joined: Thu Dec 30, 2004 10:23 pm
- Location: South of Denver, CO
Re: Excel Question
Good to know. Sadly, mine came unchecked so that's not my fix. At least it's pretty rare...
-mf