Strange Characters Appears
Sep 16, 2009there is a strange character that appears in an excel spreadsheet. It looks like a square with a question mark in it.
what this means and am I able to remove them
ADVERTISEMENT
Strange Characters Equal EOF
May 28, 2006I made a userform that spits out 'logs' in a more readable easy to understand. It basically shoves everything into a nicely organized list box.
I have a load button that if pressed accepts .csv's
It works perferctly for practically every type of .csv that contains these logs however 1/100 times the logs contain korean or chinese characters which cause the program to crash.
I gone through some debugging and I found out that the characters that cause it to crash happen to equal the EOF character. So not only does it spit an error on that line, it stops loading anything after that point.
Here is my CheckFileSize function that runs first to tell me how long I should make my list.
Private Function CheckFileSize(ByVal TempFileName) As Double
Dim TempData As String
Dim SizeCount As Double
how to do this besides loading it into a worksheet first?
Strange Characters Pasting To Textbox
Dec 20, 2006it is a very simple marco. It contains a textbox input within a user form. The only problem I have is, when I use CRTL-V to paste some text into the textbox, it has a wired character attached to the end of the text.
for example, I highlighted an email address (ex. abc@abc.com) from an email, use CRTL-C to copy, and I make sure that there is no space after the .com, and after I pasted using CRTL-V to the textbox, a wired character, like a reversed P sign..... very much like the carriage return in MS Word, would anyone know how to avoid that or disable that extra character?
Remove A Strange Scroll Bar
Feb 27, 2009I dont know the real name about this scroll bar (like you can see in my attachment), so I cant search in the forum, sigh! how can I remove the bar in the red circle?
View 3 Replies View RelatedStrange INDEX Phenomena?
Oct 8, 2009INDEX(Sheet1!$F$2:$F$10,0,1) returns #VALUE!
INDEX(Sheet1!$F$2:$F$100,0,1) returns 110 (e.g.)
As Both index have zero(0) for its row reference (row_num) I would expect both formulas to return #VALUE! (or even #REF!)
Strange Round Off Error
Jun 16, 2006when mixing data types: a real and a complex as in
=IMSUM(-G1/2,IMSQRT(H1))
if G1 and H1 are both exactly equal to 4, the answer whould be 0
see [url]
and look at location I1 (highlighted).
Strange Thing Only On One Computer Running This XLS
Feb 4, 2009Copy of the scaled down Workbook are enclosed. Password is "j". Sheet("Final Schedule") is one of 11 sheets in the Workbook. Range("a10: BE120") is copied from another Sheet and pasted.
ISSUE BACKGROUND: Entries into cells are Data Validation and a drop down on each cell. In cells C15, 16, 17, 18 or O15, 16, 17, 18 First time the Sheet is opened: user has no problem if they select a D from the drop down.
ISSUE:
But if user types in D and hits enter key, contents of G10: M10 (merged cells) is copied into that cell. Any thoughts on where to check or what settings to check? It only happens on that one computer.
Today Function Works Strange
Aug 24, 2009I have a column, where i want to calculate the difference between today and another date/or viceversa. The problem is, that in the first two cells, it calculates it well, but then, it shows #VALUE and when I press to see the "calculations steps" , it shows "29/09/2009"-40049. It turns the today function into a number. Why?
View 11 Replies View RelatedReferencing To CSV File In Strange Format
Oct 21, 2009I am working on an excel dashboard to display life information about energy consumption.
there is currently a bespoke syatem which does this but we need the dashboard to be changed so the job has fallen to me.
Energy usage across the site is recorded in a spreadsheet (automatically) every half an hour and is saved in a folder named CSV data, however the files are saved in a format which i assume is something for the current package: *.ew7
I can open and view the data by clicking "open as" and selecting excel.
I can reference to this data from another excel spreadsheet (dashboard) whilst they are both open it will update.
However when i close all spreadsheets and open just the dashboard it tells me that the links cannot be updated.
I need a solution or a way around this so i can reference from one workbook to another.
Has anyone had any experience of this kind of thing? can anyone offer a humble analyst a bit of advice?
I was not able to attach the file here (as its in the ew7 format) but i have uploaded it to rapidshare for anyone who wants to take a look...
Increase In Decimals Returns Strange Result
Jul 21, 2006I have discovered a strange thing about excel and it is driving me mad and ruining my project.
Basically, If i enter the number 97.4 into cell A1 and then 97.165 into cell B1 and then enter the formula =A1-B1 into cell C1 i get the answer 0.235. Which is correct.
However, when you increase the number of decimal places to 30 the answer that is returned is 0.234999999999999000000000000000.
This calculation result seem to fluctuate wildly depending on the primary numbers in cells a1 and b1. Very rarely have i seen the full 30 decimal places without a bizarre result like this.
Maybe it has been too many years since i was at school and that i am confused with my numbers and that there is a real easy answer to why this result is returned.
As i said it is ruining my project that i am working on. Can anyone help? Why does excel do this? Is there a way to stop this happening? My project relies on this answer to be correct. Is there a way to force excel to stop doing this?
To Rid Fields Of Strange Social Security Numbers
Mar 16, 2007weeding out a huge file I have of 10,000 users. When the usernames and social security numbers were entered originally, there were many mistakes on the social numbers, some were longer than 9 numbers and some were shorter....well now I need to delete the rows of the numbers that are nonsense, so I need help in finding or creating a script that goes thru my XLS file and strips out all the rows with less than 9 or more than 9 characters....can someone direct me on how to do this? here is an example of what im talking about
484818227 | John | Doe |
283298383 | Bob | Smith |
2039022221 | James | Dean | <--------need this row removed
293938832 | Billy | Bob |
29832E | George | Bush | <--------need this row removed as well
Value Appears Hide The Row It Appears In
Nov 12, 2007Is there a way to get Excel to look down a column for a particular value and where that value appears hide the row it appears in?
We have a series of reports which all have the same template, however we don't want some customers to be able to see some of the products as these are own-label products for which aren't offered to everyone.
I'd like to add this as a macro to a combo-box so that the user can view a report for their customer and then send a copy to the customer with the knowledge they won't see anything we don't want them to...
Bulk Convert Strange File Format In Multiple Folders.
Oct 27, 2009I have a series of files in *.ew7 format (i know its a random program)
I have some code which i can run which will simply open the relevant file and save it as xls.
The files are saved in multiple folders in format "yymm" eg: 0910 - oct 09.
inside each folder there is a ew7 file for each day in rthe format: "01ddmmyy" eg 01271009 = 27th oct 2009.
I have folders going back as far as may 2002 (in folder 0205) and i need a way to convert these all into xls format and save them in the same location.
Macro Worked For 2 Years, Suddenly Started Giving Strange Results
Jan 20, 2009I have a VBA macro that I pieced together* a couple of years ago to help with a pretty simple task. We have two excel sheets that pull in information daily from different sources. The macro copies and paste values for the worksheet, then 1) saves a copy of the values only worksheet with the current date, 2) resaves the values only worksheet as a .csv file that is then manually uploaded into our database.
View 3 Replies View RelatedExcel 2010 :: Clear Chevron Characters And Characters Inside Chevrons
Jan 17, 2012Is there an Excel formula to remove the spacebar + characters in red, as shown below? I need to be left with only the last name, first name and the semicolon.
Mouse, Mickey ;
Microsoft Outlook has changed the way that email addresses from the global addressbook copy and paste (from version 2003 to version 2010).
Conditional Formatting Counting Characters If Less Than X Characters
May 13, 2009I'm trying to use conditional formatting to highlight cells in a column that have less than 8 characters.
I know the LAN function, but I don't know how to make it work for the conditional formatting.
Name Appears Instead Of The Employee ID
Sep 11, 2007SEE ATTACHED FILE
All,
I have a spreadsheet that lists each employees hours for the last 4 pay periods...each is in it's own row I am trying to find out their average.
I am using the subtotal function to average their hours and that works fine. BUT...my boss doesn't want to see 4 rows for each person. He just wants to see one row for each person and when I collapse the rows, it only shows the employee's ID, not the name (because that's what I told the subtotal function to do...add subtotal after every change in employee ID).
name appears instead of the employee ID? That's useless to him because he hasn't memorized all the Employee's IDs.
Pop Up Appear If A Persons Name Appears More Than Once
Jun 20, 2008I would like to have a list of names in column A1 Smith, A2 Jones, A3 Johnson etc. Everytime someones name appears in E1-E20 I would like the adjacent column next to that persons name to turn red. Example: I type Smith in E14 -> B1 turns red. If it's not too complicated it would be good if excel could recognize the name in any font,capitols etc.
Lastly if I could have a pop up appear if a persons name appears more than once in column E that would be great. Example type Smith in E1 and then when I type smith in E4 pop appears--Name already used once do you want to continue?
Warning Sometimes Appears
Oct 24, 2007I have an Excel file that contains macros that I made. Sometimes when I open the file I do not get prompted to enable macros. I DO want to get prompted so I can enable the macros. Any idea why this happens? By the way, my macro security is greyed out so I cannot change it.
View 3 Replies View RelatedMacro Recorder Appears
Jun 10, 2009I used macro recorder, and this code was the result. Is there a way to shorten this code up? The more I use macro recorder, the more I'm beginning to realize that the code generated from macro recorder can be very sloppy.
View 8 Replies View RelatedDifferent Value Every Time Certain Value Appears In Column
Dec 22, 2011I'm putting together some data for a pivot table.
In Column Q I have a list of products. In column E these products are listed a number of time (depends on the number of regions which may change). What I am looking to do is have column A show "1" the first time the item group is in the list, "2" the second time...up to 12. Basically I'm looking to have a month (#1-12) appear in column A next to the item. If there are 3 regions then then each item will appear in the column E list 3 times. I'd like each group of 3 items to have a "1" the first time they appear, "2" the second...etc.
Here's an example....
1 - Item#1
1 - Item#1
1 - Item#1
1 - Item#2
1 - Item#2
1 - Item#2
2 - Item#1
2 - Item#1
2 - Item#1
2 - Item#2
2 - Item#2
2 - Item#2
3 - Item#1
3 - Item#1
3 - Item#1
3 - Item#2
3 - Item#2
3 - Item#2
MIN Appears As 0 With Blank Cells
Feb 15, 2007I am trying to use a MIN() function on a row of numbers; the row is not completely full (some days data was not recorded) and when I have a blank cell, the result in the MIN() frame is 0.0. This is unless of course I have a negative number (which I don't, but for the sake of argument)
This is my current function:
{=MIN(IF(AND(MOD(COLUMN($D10:$DL10),5)=1,CELL("CONTENTS",($D10:$DQ10))0),$D10:$DL10))}
It works like:
Take every 5th column starting at the second.
Try to ignore any cell that contains 0. (This I am trying to get to filter out the empty cells; I have tried ISBLANK(), ISNUMBER() and still get nothing)
Then return the cell to the MIN() function.
That is the long winded thing of it all, basically it can be summarized as this:
{=MIN(D10:DL10}
I have also tried some other code which I was told did the same thing essentially (which it does) but is shorter and nicer:
{=MIN(IF($B$5:$DQ$5="Q*",$B10:$DQ10))}
Which will check for the proper heading on each Column.
These functions work fine with AVERAGE/MAX as far as I can tell, just not with MIN().
As a side note, none of the cells leading up to this function contain "0".
Determine Last Row That A Specific Value Appears In
Dec 23, 2008I have a range ie C2:D400.
The word "ball" appears many times in this range. How do I determine the last row that "ball" appears in?
Picture Appears As Black Box
Dec 9, 2006I have imported a jpeg graphic and it appears in excel as a black box. What can i do to rectify this?
View 4 Replies View RelatedHighlight When Certain Text Appears
Dec 23, 2006I tried using Conditional Formatting, but for some reason it didn't work. I want a cell to be highlighted and/or bolded when particular text is written. It can be in any cell. This can also include blank cells (if possible within a given area such as 20 cells by 20 cells)
View 3 Replies View RelatedBar Chart Appears As Thin Line Instead Of Bar
Mar 20, 2014I am in the process of developing a tool to generate Bar charts for a set of metrics data. PFA the screenshots for the bar charts. enough spacing is needed in the bars.
ActiveChart.ChartType = xlColumnClustered
i had also axes.group=2 secondary axis.
How To Skip Cells That Appears As Blanks
Apr 30, 2014The spreadsheet that i use includes a table that some of the cells are displayed as blanks( include an IFERROR function ) I need to calculate the XIRR for a range of cells in a row that includes some of these "Blank" cells
View 2 Replies View RelatedDate Appears As Number When Add Text To The End?
Jun 9, 2014I am trying to have my cell show a range of dates, like:
5/25/14 - 5-27/14
I'm trying to use a formula like:
=DATE(2012,5,9) & " - " & DATE(2012,5,9)+2
But when I do this it just appears as:
41038 - 41040
Is there any way to tell excel to format these as dates?
Formula For Most Times Name Appears And Percentage
Dec 19, 2013The attached spreadsheet is a sample of a master sheet I need to maintain. Keep in mind that the spreadsheet has hundreds of names on it and 10 sheets in the workbook. What name appears most in the "person who called" column, then I need to know out of all the people who called, what percentage of calls he made....
I have to do this on each sheet, so if it is possible to have it work for all the sheets.
SUMIF When Text Appears Anywhere In The Cell?
Feb 5, 2014I would like to use a formula that will pull values into a sum where the values are in a column and the category is in another column. The criteria in the text cells could be located anywhere in the cell.
Example:
Column A Column B
xyzyszt (Baseline) 7890
wrxyz4sdtr (Strategic) 1234567
zecgjioae (Baseline) Infrastructure 71235
qpielcmjj ae (Strategic) New Capability 278332