Free Microsoft Excel 2013 Quick Reference

How to add a prefix to a column of numbers in an excel document?

Our company is altering the code of our item numbers. is there a way to
delete one letter from a line of symbols and add a prefix to the front at the
same time?


I have a long column of numbers that we add to daily. This column needs to
be sorted in ascending order and then printed. I don't know of a way to sort
multiple columns together so that is why it is one long column. Is there a
way to get it to print as multiple columns across a page so as to not have
numerous pages with only 1 column on each?
Thanks.

Is there a way to insert a formula, password or macro in an excel
spreadsheet that will automatically delete the spreadsheet at the date you
specified?

thanks,

Charlie

Hi everybody;
How can I write a macro to add a new column to the right of the last
column of my sheet , in a way that it also copy all the formulas from
the previous column?
regards,
Sean

Is there an easy way to pull a single column of numbers from a worksheet with
multiple columns and export it to a comma deliniated string of text?

Thanks!
Jeff

Hi,

I need to create a chart for each row in an excel document.

Ideally, each chart would go into a new sheet, there is about 300 rows and this is an example of the data:

Doctorate Msc/MA Postgraduate diploma Postgraduate Certificate Other diploma Other Certificate Other 4.01 0.2 0.2 0.5 0 0.2 0.2 0.2 4.02 0.57 0 0.14 0 0 0 0.43 4.03 0.25 0.5 0.25 0.25 0 0.25 0 4.04 0 0 0 0 0.5 0 0.5 4.05 0.14 0.43 0.29 0 0 0.14 0 4.06 0.18 0.09 0.64 0.09 0 0 0.23 4.07 0.67 0 0.17 0 0.17 0 0 4.08 0.14 0.29 0.86 0.04 0.04 0.04 0 4.09 0.17 0.67 0.83 0 0.17 0.17 0.33 4.1 0.57 0.29 0.14 0.14 0 0 0.14 4.11 0.33 0.21 0.67 0.08 0 0.08 0.13 4.12 0.22 0.17 0.94 0.06 0.06 0.06 0.06 4.13 0.17 0.33 0.33 0.17 0.33 0.67 0

I need the numbers on the left (e.g. 4.01 etc to be the title and doctorate etc to be the column headings. Can somebody help me with the VB code to do this?

I guess I need to create a chart and then loop through all the data but I have no idea how to do so.

Help is much appreciated,

Cheers!

does anyone know how to add a drag -down list box and if I choos a from my
list, it will give 1 to cell B1, If I choose b from my list, it will give 2
to the same cell B1, and so on. Thanks.

I have a report I run that identifies lots of rows with column A having the
word filtered, and column b having garbage. I've tried a find and replace by
hitting space bar 8 times (filtered has 8 characters) and replace filtered
with a blank cell. Column B still has garbage. How can I delete any "row"
that says filtered and have the rows compress to get rid of the large void?
I'm talking about 33,000 rows being gone at one time instead of blocking and
deleting, blocking and deleting, etc.... Can anyone help with instructions
on how to delete the numerous rows of garbage in an Excel document with one
key stroke?
--
Patmarie985

Is there a way for me to identify in an Excel macro the user id of the person
trying to execute the macro? For example, If User_ID = SmithJo Then (where
User_ID is something that Excel would make available to me somehow). I know
Excel knows user ids that users use to log into their PCs and/or network
since it displays them when I click on Tools>Shared Workbook, for example.
Thanks!

Hi all,

I need some help from the expertise.

I want to create a macro that is editable in an excel file. What I mean is that the code is visual in the file and for example the file location of the files to be opened are visable as well.

If I could get some hints or links on how to do this I'd be very happy. I have created a simple excel file to try to visualize my idea what I would like the macro to do.

The thing is that I've seen this being done but I don't really know the best way of doing it.

Thanks
Niklas

Is it poss to have a printable watermark behind data in an Excel worksheet?
Using Excel 2002.

Hello

Does any one know how to add a word or number at the front and end of the column
example

BAM-022311 BAM-022411 BAM-050200P2 TO add WEBOE in the front

WEBOEBAM-022311 WEBOEBAM-022411 WEBOEBAM-050200P2 WEBOEBAM-051900P2

My next one I need help in is place a a number at the end but have it go up each row

example

WEB00000
WEB00000
WEB00000

TO
WEB000001
WEB000002
WEB000003
WEB000004

and so on.

I am working on this project & I cant figure out how to add a letter in
front of each number in a cell without clicking in to each individual cell
and typing it in. (very time consuming and tedious) The problem is - it's not
all the cells but a majority, all of the numbers are in the same column. To
explain, these are documents in storage. Each item is assigned a number (not
in any particular numerical order but they have to stay in the order they are.

Example:

X39655
X39656
X39711
39662
39664
39665

The last three numbers need the X in front of them.

Any ideas? Thanks so much!!

I read this previous reply and I'm not getting it.......I'm Excel challenged
:-(

Use a help formula

=Sheet1!A1&"scc"

copy down/across, then copy and paste special as values in place ,
finally replace the old values with the new

Regards,

Peo Sjoblom

I am working on this project & I cant figure out how to add a letter in
front of each number in a cell without clicking in to each individual cell
and typing it in. (very time consuming and tedious) The problem is - it's not
all the cells but a majority, all of the numbers are in the same column. To
explain, these are documents in storage. Each item is assigned a number (not
in any particular numerical order but they have to stay in the order they are.

Example:

X39655
X39656
X39711
39662
39664
39665

The last three numbers need the X in front of them.

Any ideas? Thanks so much!!

I read this previous reply and I'm not getting it.......I'm Excel challenged
:-(

Use a help formula

=Sheet1!A1&"scc"

copy down/across, then copy and paste special as values in place ,
finally replace the old values with the new

Regards,

Peo Sjoblom

I have a single column of different numbers in 33,000 rows. I need to add a prefix in front of each number for all 33,000 numbers. The prefix is BB/. I have tried the 'replace' command tool which does work but far too time consuming for all those different numbers. Is there a shortcut to achieve this ?

Hi All,

I am trying to figure out how to add a fixed amount in percent (ie. 10%) to all cells in a column.
Here is an example:

Price:
1.00
2.00
2.50
3.00
3.00
5.00

I want to add 10% to everything in the above column to give:

Price:
1.10
2.20
2.75
3.30
3.30
5.50

The column has thousands of items so manual editing is not something I can complete this year ;-)

If this involves some kind of formula would this prevent me from exporting as a CSV file - or would the CSV simply contain the numbers rather than the underlying formula?

Apologies if this is a simple question but I am stumped :-?

Any help appreciated!

Thanks,

S

Hi,

How can i get a column of numbers in ascending order? I have a column "Number", and i want the column to go from 1,2,3,4,....etc. Is there any way i can just write the first number and drag it down to get the rest?

Many thanks!

I have a table of data that has my customers entered in Column A. Row 1 will have 4 columns of data per each customer for each business day of the month. For example: customer A2 will have columns B2:E2 holding data for 11/1/2010, F2:I2 for 11/2/2010 and so on. Each day captures the same type of data. For example: B2, F2 will hold daily sales #s, C2, G2 will hold the corresponding sales $ and so on. What I am looking for is a formula that will allow me to get a monthly total of column of data/per day for each customer. Again, each day holds 4 unique columns of data for that day for each customer. I want monthly totals per customer of each of the 4 unique daily columns of data. I have figured out how to add every 4th colunm of the table but am lost beyond that.
Thanks in advance. I am using Excel 2007.

Can not fiquor out how to add a comment to an entire column.
I know it can be done as the person before me has done so, and I need to
create a new spreadsheet so that when someone scolls over a certain column it
pops up with instructions of what is needed to be in that column.
I hope someone can help me..............I know it is a simple process but I
am bogged down with alot of crap right now and can not rremember how.
Help PLEASE!
Thank you

I'm using Excel 2007 and trying to graphically represent a large series of numbers to get a good visual representaion of the data.

Column C - Win/Loss Ratio W/L - (.05 - 5.0)
Row 3 - Batting Average BA - (1% - 100%)

_______1% 2% 3% 4%
___.05
___.10
___.15

Formula for 1st data point (Data represented - 1% BA; .05 W/L)
=((($C4)*(D$3*100))+(($C4-1)*(100-(D$3*100))))

This table results in a wide range of numbers with multiple price series.

Question:
What is the best graph type to use?
How can I clean it up to make it easily readable?

I'll try my best to explain this, hopefully someone can help.

I have a row of data all linked to a column of data in another workbook, so essentially the formlas are transposed but not precisely as the row data is not picking up the column data in order, ie there are some gaps, the links are not consecutive etc.

I've manully created the first set of links, now i need to replicate the links but with each formula 5 rows down.

For example IF I've linked thes cells from another workbook

A25 A27 A28 A42

and now I want to link

A30 A32 A33 A48

i.e. the same increments but 5 rows down, is there any way to just add 5 rows to my original formula?

Cheers in advance

I need to know if there is a way to find the largest change in a single
column of numbers, even if they are negative values.

EXAMPLE:
Column A1:A3 contains the following numbers
135.67
23.45
-256.77
I need to show the returned information in Cell B6.
Every function I use returns 135.67 as the largest but I need to return the
-256.77, (and show the negative sign). This is a very simple example but I
hope someone can help.

Hello, I'm using VBA in Excel XP with Win 2000

Does anyone know how to populate a multi-column activeX listbox on a spreadsheet with an ADO recordset

I am returning the field count and setting the number of columns needed in the list box, but I can't figure out how to load the list box with the data

Can I use "CopyFromRecordSet" some how? Must I convert the RecordSet into an array? What

Please supply example code. Thanks much in advance.

Depending on how your data is organized (if you have some consistant
identifier in each row you wish to sum, like the word "total", etc), you
might look at the SUMIF function

Vaya con Dios,
Chuck, CABGx3

"Fredneck Angela" I am working on Excel 2003 and trying to add a long column of numbers.
Excel
> will not allow me to enter more than 30 cells to be added. They are not
> continuous (cells in a single column, but every other row).
>
> Can anyone help?

I figured out how to round one number to the nearest .01 but i need to do
that to a whole column of numbers. Say the number is .4178, i want it to be
..42 and i want to do that to the whole column. Any help?