Free Microsoft Excel 2013 Quick Reference

How do I condense 3 columns into 1 in Excel?

I have an excel spreadsheet with contact info that I am importing into
outlook. Right now, my address' are in 3 columns (number, street,
designator). How can I combine the 3 columns into 1 column so that the
address is all together?


Post your answer or comment

comments powered by Disqus
how do i..switch the columns into rows and vice-versa....!!

How do I copy a column into a row and keep the links to other workbooks so
that they update automatically? When I transpose when pasting I lose the
option to paste the link.

Excel 2002. I do not want a mailto: html tag automatically inserted before
e-mail addresses. I don't want to send e-mails from the e-mail address list
I have typed into Excel, but I cannot deactivate the function that
automatically sets e-mail addresses up as mailto: links. How do I
permanently deactivate this auto function in Excel 2002?

How do I print a very large document in excel. I need to print so the
columns are printed first and not the rows.

Excel 2002. I do not want a mailto: html tag automatically inserted before
e-mail addresses. I don't want to send e-mails from the e-mail address list
I have typed into Excel, but I cannot deactivate the function that
automatically sets e-mail addresses up as mailto: links. How do I
permanently deactivate this auto function in Excel 2002?

How do I graph quarterly data which appears in Excel with gaps between the
mon this, like the first, and second columns below (the third column is
monthly):

Do I have to clean the data first, or is there a trick?

579.836 721.12 567.86 117.45 95.398 23412
_ _ _ 120.08 _ 23913
_ _ _ 120.83 _ 25196
586.415 732.82 575.79 121.24 _ 34446
_ _ _ 121.7 _ 26057
_ _ _ 122.04 _ 31790
584.511 738.72 580.24 122.16 _ 28815
_ _ _ 122.27 _ 30638
_ _ _ 122.29 _ 15793
594.252 744.45 587.69 122.44 _ 22563
_ _ _ 122.28 _ 27764
_ _ _ 122.25 _ 24114
597.912 750.01 589.68 122.12 100 18023
_ _ _ 124.94 _ 22988
_ _ _ 125.24 _ 23650
602.364 743.68 590.22 125.24 _ 23919
_ _ _ 125.22 _ 24943
_ _ _ 125.27 _ 24158
614.051 748.56 593.71 125.15 _ 21822
_ _ _ 125.06 _ 31242
_ _ _ 125.21 _ 16168
620.186 753.08 595.89 125.17 _ 20747
_ _ _ 125.43 _ 25912
_ _ _ 125.41 _ 24793
622.375 754.77 600.05 125.35 102.623 22105

how do i set up employee performance database in excel

Please can someone help me. How do I protect specific cells from changes in
Excel? I have a spreadsheet that I would like users to only be able to change
certain cells, the others need to be protected from change

how do I turn on/off "Design mode" in Excel 2007

I have just upgraded an entire Tax/Accounting office to Excel 2003, and they
are very unhappy about this little change.

With fixed decimal set to 2 places:
In office 2000 when you entered 20. you got 20.00
In office 2003 when you entered 20. you get .20
In office 2003 when you entered 20.0 you get 20.00

It may not seem like much but when you do thousands entries a day an extra
key stroke on half of them is a big deal.

Any chance this will be fixed?

"Debra Dalgleish" wrote:

> Formatting won't help in this case. The question is about entering data,
> when the Fixed Decimal option in on (Tools>Options, Edit tab)
>
> John Armenia wrote:
> > you could just change the cell format to the format you want.
> >
> > John
> >
> >
> > "Debra Dalgleish" > wrote in message
> > ...
> >
> >>You can add a decimal and a zero at the end of the number, to override
> >>the fixed decimals. For example, type 33.0 and it well be entered as 33
> >>
> >>CPAMichael wrote:
> >>
> >>>How do I override fixed decimal place settings in EXcel 2003? The
> >>
> > override
> >
> >>>function does not work (pressing the decimal key after enterung the
> >>
> > number in
> >
> >>>a cell.)
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

How do I create a levey-jennings chart in excel?

How do I obtain Curly quotes and apostrophes in Excel?

How do I create a drop down list in Excel 2003. I've tried to use the help
menu and I cannot figure it out.

How do I center data across multiple cells in excel without merging the cells
together

How do I resize a pie chart created in excel to make it larger?

All,

My issue is that I have 2 columns of data, Column A and Column B. What
I would like to do is combine these 2 columns into 1 that would result
in something like this:

A1
B1
A2
B2
A3
B3
etc

There are 1000+ entries in each column and I have tried creating a 3rd
column plugging into the cells the following, hoping to create the
ability to click and drag and fill the rest of the relative values:

=A1
=B1
=A2
=B2
=A3
=B3
etc

However, when I click and drag, I am not able to keep the pattern
going. It always seems to revert to something like this after I try to
click and drag the fill box:

A1
A2
A3
A4

Any thoughts on a better way to accomplish this? Or perhaps a tip to
fill the pattern down the column? Sorry if I am missing something
totoally obvious.

Any help is appreciated!

--
mayhewvb
------------------------------------------------------------------------
mayhewvb's Profile: http://www.excelforum.com/member.php...o&userid=24352
View this thread: http://www.excelforum.com/showthread...hreadid=379488

All,

My issue is that I have 2 columns of data, Column A and Column B. What I would like to do is combine these 2 columns into 1 that would result in something like this:

A1
B1
A2
B2
A3
B3
etc

There are 1000+ entries in each column and I have tried creating a 3rd column plugging into the cells the following, hoping to create the ability to click and drag and fill the rest of the relative values:

=A1
=B1
=A2
=B2
=A3
=B3
etc

However, when I click and drag, I am not able to keep the pattern going. It always seems to revert to something like this after I try to click and drag the fill box:

A1
A2
A3
A4

Any thoughts on a better way to accomplish this? Or perhaps a tip to fill the pattern down the column? Sorry if I am missing something totoally obvious.

Any help is appreciated!

I have a column of dates that I produced by putting in the first date. Then
the next and following were simply a formula =SUM(A4+7) and so on for five
years of Sundays. I wanted to have two for each sunday I could have them
sorted by AM or PM so I duplicated the list and put AM in the next column
beside the first 5 years of Sundays and PM beside the next five years.
I then sorted with column A (dates) descending and column B (AM/PM)
descending.
I expected to get 01/01/2000 AM and then 01/01/2000 PM under each other and
so on but the formulated column would not sort. I tried a sample of five
dates manually and they sorted fine but not when the dates are produced by a
formula. I do not want to have to type in five years of dates as that is the
reason we have formulas. How do I sort the formulated column???????

How do I get caps lock to work in excel with speech recognition ?

I've moved my access database and I have an excel file with multiple exturnal
data imports.

I can change the query easily but I can't find an option to repoint the
query to the databases new location. How do I change the location of the
database excel is querying?

I have a shared workbook with several huge spreadsheets. There are certain
things that other users/viewers would readily want to know without parsing to
the end of the spreadsheet. How can I create a floating text box in Excel
and include totals of certain cells from the same worksheet?

How do I make a back up file in excel?

In my excel file, the address is split into 4 columns. I want to combine the
4 columns into 1.

I am new to excel and do not have macro experience. I wd like to make
columns 1-6 All Caps when i hit tab or enter. then I want another
column to format proper caps when hit tabe or enter.

I copied a macro from this forum to make the first 6 columns ALL CAPS
which is working beautifully, see following:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column > 6 Then Exit Sub
On Error GoTo ErrHandler
Application.EnableEvents = False
Target.Formula = UCase(Target.Formula)
ErrHandler:
Application.EnableEvents = True
End Sub

How do i now make column 7 format proper?

--
rmm30

------------------------------------------------------------------------
rmm30's Profile: http://www.excelforum.com/member.php...fo&userid=8358
View this thread: http://www.excelforum.com/showthread...hreadid=378562


No luck finding an answer? You could always try Google.