Free Microsoft Excel 2013 Quick Reference

How to change cases from small to capital in all cells?

I have to change the case of all characters from small to Capital in all
cells of an excel file (Excel 2003 and lower).
MS Word has a command called: Change case, which changes the case of
selected letters from Capital to small and vise versa. Is there any
equivalent of this command in Excel? I couldn’t find it. If there is not,
what is the fastest way to change all letters from small to Capital in Excel?
If there is any Macro or VBA solution, please let me know.
One way might be to Copy/paste to word, do the change and return.

--
Rasoul Khoshravan Azar
Kobe University, Kobe, Japan


Post your answer or comment

comments powered by Disqus
Can someone please help me figure out how to change the "Y" axis value in a
line graph in Microsoft Excel from percentage to the value that I want it?

can someone tell me how to add numbers from different places in a chart
i.e. lets say 10 numbers are in different places and I need the total
of these ten- is there a way of obtaining this by selecting them
without putting in all the numbers separately somewhere to arrive at a
total.

Can a table be imported from word into excel. i.e a multi row table
with 2 o r 3columns and it visually will look like its in normal view
word but in excel. can someone tell me.

--
carole
------------------------------------------------------------------------
carole's Profile: http://www.excelforum.com/member.php...o&userid=34643
View this thread: http://www.excelforum.com/showthread...hreadid=550818

can someone tell me how to add numbers from different places in a chart
i.e. lets say 10 numbers are in different places and I need the total of these ten- is there a way of obtaining this by selecting them without putting in all the numbers separately somewhere to arrive at a total.

Can a table be imported from word into excel. i.e a multi row table with 2 o r 3columns and it visually will look like its in normal view word but in excel. can someone tell me.

I am working on spreasheet with 9000 lines. I need a shortcut to copy and
paste same formula in all cells.

Is there a way to change case from upper case to sentence case throughout I know how to in word but I'm not finding that option anywhere in access.
Thanks a bunch!

I am drawing a column chart for the dynamic scales in a music piece. Data
value in the z axis refers to other customary names (texts). For example, 7
represents ff (fortissimo), 6 represents f (forte), 5 for mf (mezzo forte),
etc. I want to show these customary names instead of the values in the
labels. Could anybody teach me how to change these tick mark labels in z axis
from values to texts?

I am drawing a column chart for the dynamic scales in a music piece. Data
value in the z axis refers to other customary names (texts). For example, 7
represents ff (fortissimo), 6 represents f (forte), 5 for mf (mezzo forte),
etc. I want to show these customary names instead of the values in the
labels. Could anybody teach me how to change these tick mark labels in z axis
from values to texts?

Can someone please help me figure out how to change the "Y" axis value in a
line graph in Microsoft Excel from percentage to the value that I want it?

Hello
could you tell me how to change the default file name in
the dialog "save as" or "save" without opening the dialog
or save the file
tks in advance..... I am really stucked....

Hi TWIMC

I need to how to change a proportion of text in a resulting concatenation
formula.

cell A1 contains the text in bold "ABCDEF", cell A2 containes "GHIJKLM" cell
A3 contains =A1 & " " & A2 but I want the cell A1 part to remain in bold. Is
there a way of using the TEXT function e.g. =TEXT(A1,BOLD) & " " & A2?

TIA
KM

Guys,

I wonder if you can assist me;

I have a range of cells that have text formatted in the following way;

Ancillary (900)BABY (300)BATTERIES (100)CELEBRATIONS (550)CLOTHING (700)DIY (600)ENTERTAINMENT (150)FOOD & DRINK (850)GARDENING (450)HEALTH & BEAUTY (200)HOMEWARES (400)HOUSEHOLD (350)PET (650)SEASONAL/EVENTS (480)STATIONERY (750)TOYS (800)XMAS (500)

I need to change the arrangement of the cells so that the Brackets and numbers appear in the cell before the text, how can I achieve that?

Poor example but each cell will only contain one of the above variants, not all of the variants.

Any help is most welcome and appreciated.

Hello everyone

Does any body know how to change or remove the TitlebarIcon from an
Excel Workbook.
In MSAccess you can do that in the menu> options>startup
In Excel, as far as I know, there's no feuture like the one in Access.
I do know how to change the Titlebar Caption.

Thanks in advange,

Teuntje

--
Teuntje
------------------------------------------------------------------------
Teuntje's Profile: http://www.msusenet.com/member.php?userid=806
View this thread: http://www.msusenet.com/t-1870395627

I want the ability to change the drop down list in a cell and the vlookup formula in another cell based on the value in a different cell.

Scenario:
table tab contains a number of named lists. Lets call them Manufacturers, Models (one for each manufacturer), and Info (one for each manufacturer).

In the main tab cells in column 1 contain a drop down list of the Manufatcurers. When a manufacturer is selected I want the cell in column 2 (same row) to be cleared and the drop down in that cell to reflect the models for that manufacturer. When the model is selected I want the vlookup in the cell in column 3 (same row) to search a list (one for each manufacturer) based on the model. I know I'll need some VB code but not sure what I need.

Thanks
Don

How to recover data from damaged workbooks in Excel 2002 and in Excel 2003

I want to do it automatically for a group of cells.

for example, if the word in a cell is "a b c", after spaces are
removed, the new word in the cell will be "abc"

how to do it by using VBA? thanks!

Example: I have a workbook with 3 sheets: Report, DeptA, and DeptB. When I
change the value in the cell named Dept in Report to "A", I want the other
cells in Report to retrieve values from DeptA spreadsheet, and when I enter
Dept="B" I want the values from the DeptB spreadsheet.

In other words, I want the reference to the other worksheets to change based
on the value in one cell. Can I do this by combining formulas or do I have to
use VBA?

I tried something like [="Dept"&(dept)&!A1] (if A1 was the cell I wanted),
but got problems combining text and formula. I know I could use IF, but not
if there are 20 different sheets. Besides, shouldn't there be a more elegant
way to do this?

I want to know how to change the font that appears in the formula bar. Also
is it possible for the formula bar to mirror the display on the cell. For
eg., the entry in the cell is 2,520 but appears as $2,520 by using the
currency format. Is it possible for the formula bar also to display the
number as $2,520....it usually displays 2520.

I have an excel spreadsheet where I would like to change some text but not all of the text.

Example

The spreadsheet says: Non Data East Stores

I would like it to say: No Volume East Stores

Take note that there are 4 spreadsheets I run this macro on and I only want to change the first 2 words and keep the East/West/North/South Stores the same depending on which spread sheet I run the macro on.

Here is what my code looks like now:
This will then display in the West spreadsheet and the North and the South.  

Any help would be appreciated. Thanks in advance.

Example: I have a workbook with 3 sheets: Report, DeptA, and DeptB. When I
change the value in the cell named Dept in Report to "A", I want the other
cells in Report to retrieve values from DeptA spreadsheet, and when I enter
Dept="B" I want the values from the DeptB spreadsheet.

In other words, I want the reference to the other worksheets to change based
on the value in one cell. Can I do this by combining formulas or do I have to
use VBA?

I tried something like [="Dept"&(dept)&!A1] (if A1 was the cell I wanted),
but got problems combining text and formula. I know I could use IF, but not
if there are 20 different sheets. Besides, shouldn't there be a more elegant
way to do this?

hi all,
i want to embed objects from other applications by drag and drop in 1
cell in excel sheet, specially outlook express objects like mail,
drafts , contacts etc as embedded objects. these embedded objects
should be openable in the source application (if excel supports it).
Also the object should be represented as an icon.
This is possible in MS word but when try to drag and drop in excel
sheet , the outlook object doesnot go into 1 cell , it goes in to a
range of cells.

Thanx for help in advance.

Hello there,

so this is what I am trying to do
I have this huge data set by columns Q.1, Q.2, etc.
I defined the name ranges so that all data from one column can be refered by its header

so now I am creating some graphs using name ranges, and I would like to change the name range refered in all cells of the graph easily, for example changing one cell where the range name is written.

to create the data for the graph I am using the COUNTIF funcion, and I have to enter the range as the first agrument -- however if select the cell where the name range is written it does not take it as such and just counts the appreances on that very same cell. I also tried to put that text in the formula using CONCATENATE (and concatenating with nothing else), but it does not work either.

Is there any workaround for what I am trying to do?

thanks in advance

Bernat

hi all,
i want to embed objects from other applications by drag and drop in 1
cell in excel sheet, specially outlook express objects like mail,
drafts , contacts etc as embedded objects. these embedded objects
should be openable in the source application (if excel supports it).
Also the object should be represented as an icon.
This is possible in MS word but when try to drag and drop in excel
sheet , the outlook object doesnot go into 1 cell , it goes in to a
range of cells.

Thanx for help in advance.

Hi all!
I know there is a formula how to retrieve information from multiple sheets. In my workbook I have 60 sheets (similar layout) and a graph sheet. So in order to make charts working, I have to pull data out of theese 60 sheets. Let's say, in graph sheet I have to sum every sheets H column data. I have made a dummy example for you to look at.
Thanks guys!

See attached...

I have a column with various expressions. I want to do the following substitutions in all cells of this column:

1. substitute "-" with "-"
2. substitute "FT" with "FORT"
3. substitute "MT" with "MOUNT"

I know I can use =SUBSTITUTE(A1,"-"," ") etc, but can I make all the changes at once, with one function?


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