csv-file-lines back to excel rows and columns
My Excel-version is 2002.
I am working with long lists of Attendees for courses and
get them in csv-format, so all Data are in long rows with
commas inbetween. But I need them in rows and columns, name
under name, adress under adress and so on. Is there a Way
to convert them from csv to rows and columns?
You may want to post a sample (not the workbook) of how your data is laid out.
And if the data is all in a long column (not row), then is each group delimited
by anything (blank row)??
Or is it x rows per group?
You'll get different suggestions based on the l...remove or hide blank rows
I have a problem with excel, i have one sheet with a lot of information of
project that are plannend for a prefered month. I want to make a list on a
other sheet for each month. I want to use the name of the month to generate
this sheet. How do i leave the blank rows(because there for a other month)
out of this list?
Message posted via http://www.officekb.com
Try using Data | Filter | Autofilter to hide all non-related information
prior to copying and pasting into the other sheet.
MS Excel MVP
"Erik Beijlen via OfficeKB.com" <forum...switching axis
How do I switch the Y axis values so they show in the X axis and vice-a-versa?
Example: I want to create chart showing dates on the X axis and my
categories on the Y axis. Basically, I want to create a timeline based off
of my table that has one column of different events and another column
showing the dates they took place. Is this possible?
You can use a gantt chart to show the timelines. Jon Peltier has links
to sites with instructions:
> How do I switch the Y axis values so they show in the X axis and v...Row Height when Wrapping Text
I have a program that saves to excel. When saving
comments to excel, it wraps the text in a row. I want to
continue to wrapt the text. Is there any way to
automatically change the row height to fit the text (the
text is more than one line)?
The default is to autofit. If you have changed the row height, then this
disables the autofit. Select the row and do Format=>Row=>Autofit.
If you have merged cells, then this won't work.
<email@example.com> wrote in message
> I have a ...vertical column to horizantal data
I have been copying and pasting data to and from a column in Excel and
various other utilities like notepad. I need to have the vertical
data/cells (1,000+) in a horizontal format. Is there a quick easy way to do
In other words:
How can I change one long column into one long row?
"NewsGuy" <firstname.lastname@example.org> wrote in message
> I have been copying and pasting data to and from a column in Excel and
> various other utilities like notepad. I need to have the vertical
> data/cells (1,000+) in a horizonta...Switching axis of a chart
Operating System: Mac OS X 10.6 (Snow Leopard)
I want to switch the x and y axis of a simple line chart.
Let me add more info in hopes that there is someone that can help me. <br><br>I have two data series in columns. <br>
Series one is <br>
1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20 <br><br>Series two is <br>
1,4,9,16,25,36,49,64,81,100,100,81,64,49,36,25,16,9,4,1 <br><br>I am trying to draw a line graph that puts series one on the y axis and series two on the x.
I cannot ...Search columns on multiple worksheets
In a workbook I have a worksheet for each month of the year. How would I be
able to automatically determine whether the entry currently being made has
been entered in the same column previously on any of the worksheets?
(Similar to “Find” under Edit) If so, would it be possible to indicate the
previously entered data by highlighting each duplicate cell?
I suggest you start with Chip's site www.cpearson.com which has lots about
Then come back with more detailed question
Bernard V Liengme
Microsoft Excel MVP
remove caps fro...Changing column views
When I go into view-> columns and change the columns that I want to see in my
view, it only saves the changes for that session. IE when I go back into
Mail later it has reset to the original columns! How do I keep the view
changes that I want permanently??
"Vic33" <Vic33@discussions.microsoft.com> wrote in message
> When I go into view-> columns and change the columns that I want to see in
> view, it only saves the changes for that session. IE when I go back into
> Mail later...How can I add a column of names for example
I have A2 = adrienne, A3 = Joe how do I do the formuala to make their names
This formula counts the number of non-blank cells in A2:A5
Does that help?
Microsoft MVP (Excel)
(XL2003, Win XP)
"christina" <email@example.com> wrote in message
>I have A2 = adrienne, A3 = Joe how do I do the formuala to make their
> = 2
"Ron Coderre" wrote:
> This formula counts the number of non-blank cells in A2:A5
>...How do I sort using text located in different columns?
I know this is a bad design, but in my worksheet I want to sort using text
entries (for example," dist" or "bp") that are (or may be) located in five
separate columns. The entries have the same meaning regardless of column,
and I want to capture all of the entries in a single sort. Is this possible,
or do I need to go to a relational database? I don't want to construct a
worksheet with separate columns for each entry type because there are simply
too many types. Thanks.
Does this mean that there is only one " dist" or "bp" in those 5 column...Stacked Column Chart
I have this stacked column shart with 3-D visual effect, in which I would
like to decrease the height of the columns vis-vis the plot area as I need to
insert text boxes in the plot area over the columns. How do I go about it?
Can somebody pl. help me with this?
Increase the Y axis maximum so that the columns do not reach so high.
If you're adding textboxes, make sure you select the chart before adding the
textboxes, so they are embedded in the chart, rather than in the worksheet.
Also you will be well served to change to a 2D chart, otherwise it will soon
become very clutt...Excel bug
recently I have got a strange bug in Excel after running VBA code. Left
columns got covered with a sort of extended border / frame and were not
accessible anymore. How can Iget rid of this? It happens now time - to
Any help welcomed. I attach the creen shot
|Filename: Excel_Bug.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4264 |
-----------------------...Multiple Columns Group Footer
I have created a report with multiple columns. Each Group has a total count
and summary in the Group Footer. Can someone tell me how I can show this
total on the same line of the printed report (as each column contains
different numbers of records)?
Thanks in advance.
"D. M." <DM@discussions.microsoft.com> wrote in message
> Good Morning,
> I have created a report with multiple columns. Each Group has a total
> and summary in the Group Footer. Can someone tell me how I can ...Creating a Formula to Format Column automatically? #6
What if I wanted to do more than three conditions
bludovico's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1480
View this thread: http://www.excelforum.com/showthread.php?threadid=26434
You can have 4 conditions.
1. The default
2,3,4 other conditions.
More than that would require Code, most likely Event code.
Option Compare Text
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Num As Long
Dim rng As Range
Dim vRngInput As Variant
Set vRngInput = I...stacked bar, and column, two axes
with a stacked bar, and a column, on two separate axes, the current chart has
the column that's on the second axis right over top of the stacked bar.
Is there a way to move the column so that it is beside the stacked bar, not
on top of it?
The manage would also like to add a line, in addition to the stacked bar and
the column. ??
sort of gettin' it.
Do you mean a stacked column on the primary axis, and a single column on the
secondary axis? Because stacked bars run horizontally and stacked columns
Is it possible to remove rows that are blank in some column?
Suppose I have
And want to remove rows with a blank in column 1 and collapse the whole array to
Wayne T. Watson (Watson Adventures, Prop., Nevada City, CA)
(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
Obz Site: 39° 15' 7" N, 121° 2' 32" W, 2700 feet
"Academic disputes are vicious because so little
is at stake." -- Anonymous
...two lines of text in a single row?
I would like to enter two lines of text in a single row (using ALT-ENT), but
I don't want to merge cells. It's ok if the text spills across adjacent
columns. And I don't want the text to wrap. Any ideas?
You will have to widen the column
"SteveB" <SteveB@discussions.microsoft.com> wrote in message
> I would like to enter two lines of text in a single row (using ALT-ENT),
> I don't want to merge cells. It's ok if the text spill...Selecting only odd numbered rows
I have a spreadsheet with data on all the even numbered rows. All th
odd numbered rows are blank. The data is imported into the spreadshee
from a text file.
How can I select and delete all the odd numbered rows which have n
data in them? (Manually doing this is not an option as there are 15
different spreadsheets with approximately 2500 rows of data on each
Message posted from http://www.ExcelForum.com
Can you do a sort or autofilter on the data ?
That way all rows with data should be in the top half.
"Alan T >" <<Alan.T.firstname.lastname@example.org>...Get the difference of two values which are on the same row , on t.
If I want to maintain my daily expenditure on the worksheet of Excel, I need
to enter some data on the same day ( or same row of the sheet ) as shown
Date Money in hand Expenditure Balance
15-10-2007 2800.00 500.00
I should get the balance as 2300.00 on the Balance column. How can I get it
on the sheet automatically, after filling first 03 columns?
...FRX row format, MDA codes should allow me to use wild card charac.
FRX row format, MDA codes should allow me to use wild card characters, such
When using MDA Group and/or MDA Code within FRX you must explicitly enter
the code IN FULL
Use of wildcards is not supported, nor permitted.
You will have to list each Code individually as you illustrate in your
"Raja V" <email@example.com> wrote in message
> FRX row format, MDA codes should allow me to...columns #5
Can I add columns beyond IV?
Tony, no. Column IV is the limit.
"DDM's Microsoft Office Tips and Tricks"
"Tony" <firstname.lastname@example.org> wrote in message
> Can I add columns beyond IV?
> Can I add columns beyond IV?
...sum text in vertical + horizontal columns
I am producing a rota for my workplace.I can sum up the amount of shift
staff do horizontally( left to right) using the sum function.Howeve
what i want to do at the bottom of each column is add the number o
staff on duty.I can do this using the sum function but it adds up al
the letters i have in each column.EG H=Holiday so when a H is on th
rota i dont want it to add to my total at the bottom of the colum
D=Duty i have 4 staff on each night so in each column i could have
Duty 1 on H and 1 S off sick i now get a total of 6 when i really wan
it so show 4 automatically as i want the H & S n...Next-To-Last, Non-Blank, Rightmost Value in a Row
Consider a single row and ten columns.
Some or all or none of the cells in the row will have non-numerical data.
Can anyone provide a formula that will display the next-to-last, non-blank,
rightmost value in the row?
From the sample data below, the result would be "Dog"
Column A - Mom
Column B - Dad
Column C - (blank)
Column D - Sis
Column E -(blank)
Column F - Bro
Column G - Dog
Column H - (blank)
Column I - (blank)
Column J - Cat
Column K - (FORMULA WHICH PROVIDES THE ANSWER)
Thank you for your consideration and support.
=INDEX(1:1,LARG...CListCtrl and row highlight
I have a question regarding CListCtrl.
When a list control has entries in it and a user clicks on a row (i.e. the
control has focus) then that row is highlighted. However as soon as the
control loses focus (i.e. a user clicks on some other control) then the
row's highlight colour changes by default. Is it possible to disable this
so that the row is still highlighted in exactly the same colour regardless
of whether it has focus or not?
Thanks in advance for any help anyone can pass on.
add style LVS_SHOWSELALWAYS
Check the following example:
http...move a row of data from one work sheet to another using a formula
Hello, I am trying to create a formula that will move the contents of an
entire row in one worksheet or multiple worksheets into a single worksheet
that accumulates all the rows. Specifically, I have multiple worksheets
created that have the same format as far as the cells and rows go. The text
in each cell and row is different and some of the cells contain formulas.
There will be a column of cells with no text in each worksheet. When I enter
a number into that empty cell it changes the numbers in a few of the other
cells within that row. I want the rows with values in the c...