Confusing output from cells

:confused: 

I have made a spreadsheet that is gathering details from the user an
then forming a string.

However, in the 6th section of 8 it is causing problems.

the formulas are all much the same. an example is shown below:-

=if(b268="","",f88)

Now, B268 is empty, so the "" criteria is met, but instead of bein
nothing, the spreadsheet is counting this as a space, so that when th
text is pasted into another program, extra spaces are added!  However
the Len of the above cell is 0, meaning it has no value whatsoever.

Does anyone know anything about this?

Thanks.

Shackdelta :confused

--
Shackdelt
-----------------------------------------------------------------------
Shackdelta's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=973
View this thread: http://www.excelforum.com/showthread.php?threadid=47786

0
10/20/2005 1:27:44 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
510 Views

Similar Articles

[PageSpeed] 47

Your problem is not with Excel.  It is the other program's problem.

"Shackdelta" wrote:

> 
> :confused: 
> 
> I have made a spreadsheet that is gathering details from the user and
> then forming a string.
> 
> However, in the 6th section of 8 it is causing problems.
> 
> the formulas are all much the same. an example is shown below:-
> 
> =if(b268="","",f88)
> 
> Now, B268 is empty, so the "" criteria is met, but instead of being
> nothing, the spreadsheet is counting this as a space, so that when the
> text is pasted into another program, extra spaces are added!  However,
> the Len of the above cell is 0, meaning it has no value whatsoever.
> 
> Does anyone know anything about this?
> 
> Thanks.
> 
> Shackdelta :confused:
> 
> 
> -- 
> Shackdelta
> ------------------------------------------------------------------------
> Shackdelta's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=9732
> View this thread: http://www.excelforum.com/showthread.php?threadid=477868
> 
> 
0
saintolaf (56)
10/20/2005 2:59:03 PM
Thanks for that. I had already thought of that problem. It's not the
other program that's doing it.

If I copy the section that is the problem (section 6) and paste it into
Word, it comes up with a whole load of blank cells. However, for each of
these blank cells that are shown, a space is added to the other
program.

I would have thought that was the problem, but for the fact that in
similar formulae that are in use in the spreadsheet, when a blank cell
is shown no spaces are added.

Thanks again,

Shackdelta


-- 
Shackdelta
------------------------------------------------------------------------
Shackdelta's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=9732
View this thread: http://www.excelforum.com/showthread.php?threadid=477868

0
10/21/2005 2:04:27 PM
Reply:

Similar Artilces:

Mulitple text lines in a single cell
I need to type several sentences into one single cell but I can not for the life of me figure out how to get it to make mulitple text lines in one cell... It looks like this........ and I need it to look like this. Please please help! After typing each line press ALT-ENTER instead of ENTER to go to the next line in the same cell. -- -------- If this is what you wanted then press the ''''YES'''' button (if you see it) "Mrs.Aguire" wrote: > I need to type several sentences into one single cell but I can not for the > life of me figure...

Debug Output Message
I am unsure what to do. I am receiving the following message: HEAP[NcicMdt.exe]: HEAP: Free Heap block ab4a50 modified at ab4a84 after it was freed This occurs during 'OnKillFocus' of a subclassed edit control: void ILclEdit::OnKillFocus() { if (m_ModifiedInd) { CString szTemp; GetWindowText(szTemp); <<=== This call MsgValidate(szTemp); } } The call stack is as follows: NTDLL! 77f75a58() NTDLL! 77f9d959() NTDLL! 77f83eb1() NTDLL! 77f589f2() _heap_alloc_base(unsigned int 64) line 200 _heap_alloc_dbg(unsigned int 22, int 1, const char * 0x5f4d0b18 THIS_FILE, int 118)...

i am so confused
As of day before yesterday, i was recieving and sending mail like i should, but now it says my username and/or password are inncorrect, and they are stored in the com, and my phone. i retyped them, and it says the same thing??? i just tried again, and it said the following: The connection to the server has failed. Subject 'hi', Account: 'pop.att.yahoo.com (1)', Server: 'smtp.att.yahoo.com', Protocol: SMTP, Port: 465, Secure(SSL): Yes, Socket Error: 10061, Error Number: 0x800CCC0E Pleas help.... anyone!!!!! i am lost without my e-mail!! Your settings look ...

Assign a value to a cell
I'll apreciate your help with this in A1 i have a value in days that is used to make several calculations but I need it to change if a specific condition is given something lik this: A1=300 If b1<a1 then a1=b1 where b1 is a value calculated somewhere else. Thank you for your help. Rodolf -- Message posted from http://www.ExcelForum.com Hi try the following formula in A1: =MIN(B1,300) Frank > I'll apreciate your help with this > > in A1 i have a value in days that is used to make several > calculations, but I need it to change if a specific condition is > giv...

How do I change a cell range with a reference cell?
How do I change a cell range with a reference cell? i.e. cell H220 changes from =sum(G220:G229) to =sum(G220:G235) by changing cell A1 from 10 to16? =sum(offset(g220,0,0,a1,1)) "Danneskjold" wrote: > How do I change a cell range with a reference cell? i.e. cell H220 changes > from =sum(G220:G229) to =sum(G220:G235) by changing cell A1 from 10 to16? Thanks Duke. "Duke Carey" wrote: > =sum(offset(g220,0,0,a1,1)) > > "Danneskjold" wrote: > > > How do I change a cell range with a reference cell? i.e. cell H220 changes > > from ...

Cell Duplicates
I have a spreadsheet with rows of data on each of our clients in our database. I do not have access to the actual database. What I am trying to do is locate duplicate entries in the database either by the Clients name or by the email address. I do not want to have to go through each row line by line to locate them. Dose anyone know of a formula or macro I could use to locate duplicate cell entries. Hi have a look at http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates -- Regards Frank Kabel Frankfurt, Germany SMonczka wrote: > I have a spreadsheet with rows of data on each o...

CListCtrl confusion
I am confused about the meaning of selected (LVIS_SELECTED) and focused (LVIS_FOCUSED). What is the difference? The above can be set/read with Set/GetItemState(). The there is also GetSelectionMark() and its set. When you get the selection mark, is this the one that is selected? Or does it mean something else? What I am able to do is click on a row and then execute my method, doit(). Now I want to simply use the up and down arrow keys to move the selection and focus up and down the list, each time calling doit() for the new row. The problem I am running into is that I get recursive calls to...

(more!) elementFormDefault confusion
Hi all, From what I can read, it doesn't look like I'm the only one getting confused with the elementFormDefault and attributeFormDefault properties of XML schemas. I am wanting to get a full understanding of these properties, as I want to be able to generate XML that conforms to these settings via the XmlTextWriter. The two main reference articles I can find are: http://geekswithblogs.net/dmillard/archive/2004/10/20/12935.aspx http://blogs.msdn.com/ebattalio/archive/2006/03/03/543154.aspx However, I have a couple of questions regarding this: 1. In Minty Fresh's example, w...

Data Migration Manager Replace Transformation
Is it possible to create a replace transformation that can convert a multiple source values e.g. VALUE Column contains $0-10m, $10-20m, 20-30m, etc I want to replace these values with 5000000,15000000,25000000 respectively and output to a CRM attribute "new_value" which is of type "money" I can do the first value successfully using the following transformation map, but if I create another transformation map with a replacement for the second value mapping to the same output attribute I get an error saying that the new_value is already mapped. <TransformationMaps...

validity of a cell
hi everybody, i want to set a cell so that only text (alphabet) can be written there. when someone try to write number there error message will come out.Please help. thank u One way, assume it is A1 that you use, do data>validation>allow>custom =ISTEXT(A1)*ISERR(--(A1)) won't obviously work for mixed letters and numbers like A2 which can be entered. -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "melirus" <melirus@discussions.microsoft.com> wrote in message news:D7180552-315C-4DB4-...

append a string of text to all cells in a column?
Excel 2003 Is there a way to do this? The cells that I want to append to all contaio plain text. Thanks! ....Lisa Lisa Assuming column of text is A In B1 enter =A1 & "textstring" Double-click on the fill handle of B1 to copy down. Gord Dibben MS Excel MVP On Wed, 14 Feb 2007 17:37:14 -0500, "Lisa Hetherington" <gerry.lisa@sympatico.ca> wrote: >Excel 2003 >Is there a way to do this? >The cells that I want to append to all contaio plain text. > >Thanks! > >...Lisa > Thank you!! ....Lisa "Gord Dibben" <gorddibbA...

format cell #3
I have this in a cell; "2 vs 3" (without quotes), I want to find and replace it with "2 - 3" (without quotes). When I do this it either turns it into a date or a string of five numbers. I have formatted the cell to be "text" or "general" yet it still converts to a date or a string of numbers. I would appreciate any help, thank WAB WAB, Try replacing with '2 - 3. Using the single quote at the beginning will force to maintain the text. Don't worry, the sinqle quote will not show in the cell. HTH, Paul "wab" <anonymous@discus...

Confused on syntax
Hello, I confused over the following syntax. Could someone please explain to me exactly what is happening here. ((CEditView*)m_viewList.GetHead())->SetWindowText(NULL); I understand the casted type to the m_viewList.GetHead( ) function, but the ->SetWindowText call on the end is what I've never seen done like this? Is somehow the return pointer from GetHead pointing to the SetWindowText function ? But why would this be? Could not SetWindowText just be called on it's own ? On 3 jul, 13:01, "RB" <NoMail@NoSpam> wrote: > Hello, I confused over the following...

How Do I insert the Worksheet Name in Cell A1 ?
Hi, can anyone tell me how do I insert the Worksheet Name in Cell A1 ? Excel version 2000 Many thanks in advance for any help Rob -- robertguy 44 Married two kids ------------------------------------------------------------------------ robertguy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=5963 View this thread: http://www.excelforum.com/showthread.php?threadid=481872 =RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$A$1))-FIND("]",CELL("filename",$A$1))) Insert this formula exactly. Just copy and paste thi...

XSLTransform formats output html no matter what...?!
Hi, I'm transforming a XML doc with XSLTransform into a StringWriter, which I then write via the Response.Write(StringWrite.ToString()) to a web page. The problem is that during the process it parses the HTML in the XSL doc. like this example XSL: <xsl:template match="/"> <table border="0" cellspacing="0" cellpadding="0" width="320"> <tr> <td><img src="some.gif" width="5" height="6"/></td> </tr> </table> </xsl:template> OUTPUT: <table border="...

Copy cells and paste them as images in another sheet
Hello, I need to copy cells in excel and to paste them as "images" in another sheet. Is this possible ? Actually, in excel 2003, when I choose "paste special" I have only the following choices "text" "text unicode" "HTML". The reason for this is that I would like that people sort cards (in different piles) in Excel. I want to build a macro to export all my data in these images (cards). Any help would be appreciated. regards, Michael Michael Cantinotti wrote > I need to copy cells in excel and to paste them as "images" in...

Replace cell of column with cells of other worksheet
Hello, I have the following problem. In one sheet I have a table with imported keys from an access table. Now I want to replace these keys with strings that are in a second worksheet. So eg when a cell in the 1st sheet has value 2 it has to be replaced by eg "the second"... How can I do this for all the cells of that column automatically? Thanks a lot. Kristof I'd suggest VLOOKUP, if it weren't for > all the cells of that column > automatically Find & Replace is probably out, since what works for "2" will affect 12, 20, 21, 22 ... Depending ...

jump to linked cell
I have made a sheet with links to a value in a row of a named range on another sheet in the same workbook I do this with a vlookup formula combined with a value coming from a dropdown in the first sheet =VLOOKUP($B$1;vacancies;21) it's easy, user friendly and much better than how people worked before users can and have to change values in the table by hand now because of the ever growing table in the second sheet it is getting more difficult to find the right row so I was thinking of jumping to the correct cell by double clicking on the linked cell in the 1st sheet I already found th...

Deleting columns if value of cell is not matching
Hello All, I have one workbook which contains 20-30 sheets and from these i would like to check whether column C1="Expired" if value is matching then i would like to delete entire column from all the sheets except two sheet (sheet1 and sheet2). Please help in this regard.. Best regards Vikram You say " i would like to check whether column C1="Expired"...". In what sheet? Or do you mean you want to look in cell C1 In EACH sheet and, if found, delete Column C in THAT sheet? As written now, you say you want to delete column C of EVERY sheet ...

Still confused on whether this will work
Hi, I hope you can help with my question, and thanks in advance! In my use of MSMoney Plus Premium, I do bill payer through a bank directly (Wachovia) and download transactions directly using my web site passwords directly to those sites (T Rowe Price, Wachovia, Am Express for example). I am thinking this will still work after Feb 2011 (and my license goes that long), that I will still be able to get transactions automatically downloaded daily like I do now, and I can use the bank for billpayer through MSMoney? So the only thing I will lose is the stock price updates as they come fr...

Cell Comments #2
Is it possible to view the content of a group of cells in another part of a worksheet in a cell comment. I do not just want to input text but rather see the content of a group of cells. Thanks to anyone out there who can help, it's appreciated. Mike Hi this would only possible with VBA. e.g. using the worksheet_change event and creating the comment programmatically >-----Original Message----- >Is it possible to view the content of a group of cells in >another part of a worksheet in a cell comment. >I do not just want to input text but rather see the >content of a g...

Confused
I am using a shared computer at work. I have access help to resolve a simple problem and the answer is there. The big problem is that options it describes are not there for example how to set-up a signature some option names are not there and options it says should be available are different. Can someone help ?????? With the amount of missing information that you posted, probably not until the crystal ball has a nice vacation to rest up from overuse here. --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus na...

Data Cell Formula
Hi, Wondering if someone can assist please... We have a table that has the following calculation in it: =SUM(B10*60+C10)/60*E7 Which is determining the cost of a phone call using minutes, seconds and rate per second. What I need to be able to do is say that the above calculation is correct, unless the total is less than x amount (ie, .37), then that total should equal 37. This is the current train of thought, which is obviously wrong.... =SUM(B10*60+C10)/60*E7+IF(B10=0,,+E6)+IF(B10=0,,+E5)+IF(B10<=14,,(B10-15)*E4)+IF(B10>=10,+E3,) TIA Submitted via EggHeadCafe - ...

Find difference between 2 cells if critera in a 3rd cell is met
How would I find the difference between two cells depending on what is in a third cell? For example, in column G1 I want to show the difference E1 and whichever cell in column F contains the number 1. I was thinking something along the lines of using SUMPRODUCT to find the row with the #1 and then somehow subtracting G1 from the number column E that match the row where the number 1 was found. This is VERY confusing! At least, to me it is. There's probably a simple solution but I don't understand. You want the formula in cell G1? This is the really confusing part: ...

Changing the output from grid to file
Sometimes I want to capture the output in a file. I can do this in the Management Studio, but can I do this in the script itself? For example, is there a T-SQL command like "Set output file c:\test.out" You could use BCP or call sqlcmd from xp_shell. Search Google for � xp_shell sqlcmd �; for example: http://msdn.microsoft.com/en-us/library/aa260689(SQL.80).aspx http://www.sqlcmd.org/ Notice that the usage of BCP and xp_shell is subject to permission issues. Also, if it's a direct manual operation, it's simpler to use directly sqlcmd than to call it th...