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
It looks like this........
and I need
it to look
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)
> 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
This occurs during 'OnKillFocus' of a subclassed edit control:
GetWindowText(szTemp); <<=== This call
The call stack is as follows:
_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
If b1<a1 then a1=b1
where b1 is a value calculated somewhere else.
Thank you for your help.
Message posted from http://www.ExcelForum.com
try the following formula in A1:
> 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?
> 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?
"Duke Carey" wrote:
> "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.
have a look at
> 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
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
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
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
The two main reference articles I can find are:
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
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
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
won't obviously work for mixed letters and numbers like A2 which
can be entered.
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
"melirus" <firstname.lastname@example.org> wrote in message
news:D7180552-315C-4DB4-...append a string of text to all cells in a column?
Is there a way to do this?
The cells that I want to append to all contaio plain text.
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"
>Is there a way to do this?
>The cells that I want to append to all contaio plain text.
"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
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.
"wab" <anonymous@discus...Confused on syntax
Hello, I confused over the following syntax.
Could someone please explain to me exactly
what is happening here.
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 ?
can anyone tell me how do I insert the Worksheet Name in Cell A1 ?
Excel version 2000
Many thanks in advance for any help
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
Insert this formula exactly. Just copy and paste thi...XSLTransform formats output html no matter what...?!
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
<table border="0" cellspacing="0" cellpadding="0" width="320">
<td><img src="some.gif" width="5" height="6"/></td>
<table border="...Copy cells and paste them as images in another sheet
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.
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
I have the following problem.
In one sheet I have a table with imported keys from an
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
Thanks a lot.
I'd suggest VLOOKUP, if it weren't for
> all the cells of that column
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
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
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
Please help in this regard..
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
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.
this would only possible with VBA. e.g. using the
worksheet_change event and creating the comment
>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
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
Wondering if someone can assist please...
We have a table that has the following calculation in it:
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....
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:
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...