excel save as csv
I need to generate a csv file that encloses every text field with a double
quote like this - "abc", "def","ghi", etc.
Currently, excel will do this ONLY with fields that contain a comma like
this - "word1, word2", def, ghi
Any help would be much appreciated!
Take a look here:
In article <51B9385E-F0F9-4A0E-B336-497E2883EA2D@microsoft.com>,
"Newbie-Don" <Newbie-Don@discussions.microsoft.com> wrote:
> I need to generate a csv file that encloses every text field with a doub...How do I view complete text content in an Excel Comment box?
When scrolling over comment boxes in Excel, I can only partially view note
content. Is it possible to specifiy the size of the comment box OR is there
any simple method available to view complete contents of comment box while
Right-click>Edit Comment>Drag to re-size.
Or re-size all using code.
Gord Dibben MS Excel MVP
On Sun, 25 Apr 2010 02:41:01 -0700, Deaglan1
>When scrolling over comment boxes in Excel, I can only partially view note
...Setting cell tabulations( ranges) in excell
I would like to set a ranage for tabulation; the row starts with "Week day
and ends with END". You can automatically tab from WEEK day to END but to
speed things up I want the tab to go to the next row once it reaches" End".
instead of going to the next empty cell on the same row.
How can I set a tabulation range?
Week Day Date Shift Start Lunch In Lunch Out Shift End
If you select your cells (say B2:H999) first, you can tab between the cells in
dizzy kay wrote:
>...can I sort text data into bins?
Here's my problem - I hope you can understand it & help:
Let's say I've got a column, A (or row 1, it doesn't matter) tha
contains cells, each with a single word/category that I'm interested i
[example: dog, cat, bird, fish, gerbil] - we can assume that this is m
list of category headers/titles.
Plus I've also got various other columns, A-D (or rows) next to m
column A titles that each contain a list of items, one per cell: [eg
B1=dog + B2=cat, C1=bird + C2=cat + C3=gerbil].
Perhaps it would be clearer if I drew it out (ignore the dashes
they're just t...VB Code not grabbing cell values
hi, i was given the VB code below which takes all the value of cells V17 and
X25 and create a list down columns A and K on the 'graphs' sheet, it works
when i manually enter values into cells V17 and X25 and was testing it, but
it doesn't work when those cells are auto populated with data as they
calculate other cells, so the VB code isn't taking the values that appear in
those cells automatically like it should.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim strColumn As String, lngRow As Long, ws As Worksheet
If Target.Count <> 1 ...Edit text in List Control
I have implemented a List Control using List View with the detailed
style having several columns containing subitmes.
Now i want to let users change subitmes listed under two columns only.
Please, help me to figure out how to do this.
<email@example.com> wrote in message
&g...Task Scheduler or VBA to simple copy periodically folders contents to external drive
I need to copy periodically all files (without any other data
from folders W, X, Y on Drive C to folder Z on Drive D.
Any existing files would ge ovewritten without prompting.
Is it more convenient to process this through Windows Task Scheduler
or through VBA ?
If you need to work only with files, not subfolders, you can use code
like the following:
Dim FromFolders As Variant
Dim ToFolder As String
Dim N As Long
Dim FName As String
FromFolders = Array("C:\Test", "C:\Test2")
ToFo...Flag row if cell values = something specific
Let's say A1 = top
and B1 = Bottom
in C1, I want to say that if A1 = top and B1 = bottom then the cell
background color of C1 should be red.
How can I do this?
And I need to do this in a macro. I can't use conditional formating from the
I have a recorded macro that does all my formatting and I need to add this.
"Some Dude" <firstname.lastname@example.org> wrote in message
> Let's say A1 = top
> and B1 = Bottom
> in C1, I want to say that if A1 = top and B1 = bottom then the cell
> background color of...IE opens with "about:blank" url when I run my solution
Ever since I installed IE8 it opens with "about:blank" url when I run my
I close that instance and another instance opens that runs OK.
I figured when that first happened that MS would soon fix it but to my
knowledge they haven't.
Is that correct or am I missing something or doing something wrong?
...Can I add a picture to a cell?
Is there a way to add a picture to a particular cell? This way I ca
use it for look ups in other sheets. Thanks in advance for any help
Juan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=688
View this thread: http://www.excelforum.com/showthread.php?threadid=26356
not possible as pictures 'float' over the cells
"Juan" <Juan.email@example.com> schrieb im Newsbeitrag
news:Juan.1d6lzx@excelforum-nospa...Why do I get this ###### instead of 11:00 p.m. in formatted cell?
One reason could be that the column isn't wide enough. Try widening the
Microsoft Excel MVP
Always supply your formula and the values of the input cells
Microsoft MVP - Excel
"new user" <new firstname.lastname@example.org> wrote in message news:32404C0C-FB66-4D90-A301-42D0322E2CFE@microsoft.com...
On 15 =F1=E5=EF, 19:43, new user <new u...@discussions.microsoft.com> wrote=
Not to forget: if cell contains fomula that evaluates time value and
result turns to be negative, it will be shown as ###### no...Change value of checkbox at runtime (using VBA)
I will like to change the value of a check box at runtime. I have a
database with a field "multiple_print_select", which stores a value of
"1" when it is checked so that the record can be printed.
This allows only the records selected to be printed, but wen another
set of records are selected again, the previous selection are still
true, so the records are reprinted which I need to prevent.
So, I'm thinking of changing the value of the checkbox at runtime: For
instance, a VBA code that will set the value of the checkbox to "0" on
closing the report o...How to have a cell auto resize the font to make text fit in cell?
I'm using Office 2007, and I would like to know how to make the font size
automatically adjust to fit whatever I type into an individual cell.
Select the range to format
hit ctrl-1 (ctrl-one key)
Click shrink to fit
(I bet that you can find the formatting option somewhere on that ribbon!)
> I'm using Office 2007, and I would like to know how to make the font size
> automatically adjust to fit whatever I type into an individual cell.
...Randomly Choose Cells from Colum/Row
hello. i'm not sure if this is possible, but i'm trying to randomly select
multiple cells from a colum to be evaluated. for example, say i have a clumn
of 10 cells. i'd like this function in another cell to select 3 cells from
the 10 at random. is this possible? thanks
In a column next to the column containing the ten data items enter:
=RAND() and copy down. Touch F9 and then sort by the newly entered column.
This will "randomize" your data. Just take the top three cells.
Whenever you want a new sample, repeat the process
"J&qu...Pasting Word table into Excel 2000
When I copy a table from Word 2002 and paste it into Excel 2000
for some reason each row in the table ends up occupying two rows i
Excel. How can I get the table to paste properly
Message posted from http://www.ExcelForum.com
>When I copy a table from Word 2002 and paste it into
>for some reason each row in the table ends up occupying
two rows in
>Excel. How can I get the table to paste properly?
>Message posted from http://www.ExcelForum.com/
>Is the data really in two rows or are the row heighs
en...using the value in a cell as part of another cell reference
I want to use the value in one cell as part of the reference for another.
eg. A(K10). is there an easy or any way. Pretty new to this, if I'm asking
As I can't find a function or other method.
=INDIRECT("A1") refers to A1, and returns what's in A1
=INDIRECT(A1) refers to whatever A1 points to
(if A1 contains "A2" then you'd get what's in A2)
=INDIRECT("A" & K10)
(if K10 contains 5, then you'd get what's in A5)
You can also use
This one isn't confounded b...Strip non numeric characters from a cell
I have a list of contacts that I am trying to "clean-up" the data.
A column of phone numbers have been entered in a variety of different ways
(e.g. 555.555.5555; (555) 555-5555; Home: 555-5555; etc.)
How can I remove the non-numeric characters?
Thanks in advance!
On Mon, 13 Apr 2009 13:04:34 -0700, TraciAnn
>I have a list of contacts that I am trying to "clean-up" the data.
>A column of phone numbers have been entered in a variety of different ways
>(e.g. 555.555.5555...Excel 2007
I am hoping that someone can help me with two problems I am having in
Excel 2007. The functionality of copying and pasting to and from
filtered lists seems to be different from what I experienced in Excel
Problem 1) Copying (with Ctrl-C) from one column in a filtered list
into another column in the filtered list (with Ctrl-V)
When I copy with Ctrl-C it selects the cells in the list that are
visible (which is what I want) but when I paste those over another
column in the same filtered list (I have not changed the filter
settings) it pastes the data over cells that are not visible i...Highlighting text with F8 key
Operating System: Mac OS X 10.6 (Snow Leopard)
Instead of turning on text highlighting, pressing F8 on my new iMac (using Word 2008) turns on iTunes! Anyone know what I'm doing wrong or not understanding? Thanks!!
I'm not sure what to tell you - F8 in Word is still assigned to the
ExtendSelection command & works as expected here in 12.2.4 running on
10.6.3, so whatever is causing it must be at the OS level or external of
Word. Assuming that Office & OS X are fully updated, check the System
Preferences for your keyboard settings as well ...How do I change font size in multiple text boxes?
I am working in Publisher, and I have dozens of text boxes that I want to
change the font size, from say 10 to 8. Is there a way that I can select a
number of them and change them in a batch-style?
Use the Painter tool. Change the first text box, while your cursor is in the
box, click the Painter, click the next text box and so on.
Or open the font scheme dialogue, use or create a font scheme, click each text
box with the text scheme highlighted.
Mary Sauer MSFT MVP
"JustinB" <JustinB@disc...Printing question vba
I have a workbook with several worksheets , when the workbook is ready for
printing I want to print out 1 page with 3 copies of three of the
worksheets and 1 to 10 pages with three copies of another sheet, depending
of how much data it is in that sheet. My question is. How to find out how
many pages that has data in it and then just print those pages. I have data
in columns A-G. I know how to record a macro to do the first thing and then
go to the next sheet and do the same thing again.
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1, Copies:=3
One ...change text color/size/font/etc... (VC++)
When adding text to a dialog, I'd like to be able to set features like size,
color, font, bold/italic , etc.. Unfortunately, the when you add the text to
the dialog, it's the default basic font and style. I export the text, but I
can't find an obvious way in the CStatic class to set these characteristics.
I know it is possible to do. Any information would be greatly appreciated.
"axis" <email@example.com> a �crit dans le message de
> Thank you Bob, Ajay, and Aggro! All th...A cell appears "######". What's this?
I write down a type, for example "55,000", which is by default a general
type. From the menu Format, Cells, Number , I try to make it as an
accounting type(in dollars), I press ok and then my type "55,000" disappears
and appears a "#####" instead. What is this and how can I correct it? Thank
Make the column wider, the "#####" means that there is not enough room to
display the contents
> I write down a type, for example "55,000", which is by default a general
> type. From the menu Format, Cel...How do I set the distance between text and continued notice?
Sometimes the "continued" notice appears directly under or over my text and
sometimes it inserts a space. How can I make it consistent?
What version Publisher are you using? Check your paragraph settings in the
format menu. I've tried all sorts of formatting and cannot duplicate your issue.
It always leaves a blank line between the text and the "continued..."
Mary Sauer MSFT MVP
"Trish" <Trish@discussio...I need to add two text boxes from two different reports.
I am adding a value from one monthly report to another monthly report. I
keep getting #name. Please help!
> I am adding a value from one monthly report to another monthly report. I
> keep getting #name. Please help!
Give us a few more details. What are you typing into your text boxes? You
can't actually add up things in 2 different reports - reports are just ways
of showing data - I'm guessing that you are really adding up things from a
table. A common cause of the #name error is when you are trying to refer to