For ex: if the Value in the Cell is quot;3456quot; i want to change that to quot;23456quot;.
Similarly every cell should be prefixed with quot;2quot;
目前分類:title (3013)
- Aug 14 Mon 2006 20:08
How to prefix quot;2quot; to every cell in a column
- Aug 14 Mon 2006 20:08
Is there an array function or something like it?
I'm curious if anyone knows if it's possible to feed a bunch of random cells
into an array, and as those cells are populated (regardless of which gets a
- Aug 14 Mon 2006 20:08
Use array to return array of values
Thanks for taking the time to read my quesiton.
- Aug 14 Mon 2006 20:08
Shared Workbook
I have a question that I hope will be fairly simple. I have a shared
workbook on a public drive that several people change. There is a password
- Aug 14 Mon 2006 20:08
Can you search for common results in many wrksheets?
When having many worksheets open or even if I combine the worksheets into
one...can you search to have all the common results show up in a separate
- Aug 14 Mon 2006 20:08
delete picture with macro
I have added a macro that will copy a piece of word art and assigned it to a
control button and paste it over a employee on a daily timesheet. I use this
- Aug 14 Mon 2006 20:08
mail merging when you only have 2 excel spreadsheets
Here's my predicament. I have an application for medical insurance that I
need each employee of a company to fill out. I have basic data that I can
- Aug 14 Mon 2006 20:08
Excel 2002
I have Excel 2002 and would like to link 2 columns across 2 workbooks. I
know how to link the cells across workbooks one at a time, but I am wondering
- Aug 14 Mon 2006 20:08
Find, Cut, Paste and Delete
I am looking for VBA code to look in the “master” sheet and find all the “A”
s in a column.
- Aug 14 Mon 2006 20:08
Lookup Value
Hi,
- Aug 14 Mon 2006 20:08
making a sum total
I need a solution for one of the problem in excel. I will let u understand my
problme with an example
- Aug 14 Mon 2006 20:08
Named References
- Aug 14 Mon 2006 20:08
Extracting entries from long list
Dear experts,
I have a long list of students and assessment item results. The last column
- Aug 14 Mon 2006 20:08
how do i set up a worksheet to calculate the inventory?
i want to create an excel sheet where by i can get the inventory pre
calculated by just changing one or two data cells
- Aug 14 Mon 2006 20:08
Find amp; Replace Option in Excel 2003
In Excel 2003, you can find data quot;within sheetquot; or quot;within workbookquot; when you
press Ctrl-F, then quot;Optionsquot; button. How can I made quot;within workbookquot; the
- Aug 14 Mon 2006 20:08
Format change 203.00 to 203-00
How do I reformat a group of numbers like 203.00 to 203-00?
- Aug 14 Mon 2006 20:08
How do you keep charts
When copying a chart or graph, it doesn't keep the size of the original chart
or graph (length/height). How can I keep all of the charts-graphs the same
- Aug 14 Mon 2006 20:08
Links not working
Hello Everyone,
- Aug 14 Mon 2006 20:08
LEFT / RIGHT functions
I have a column of Mexican city and state names in column A. The Mexican
state names are of a variable length. What I would like to do is have a
- Aug 14 Mon 2006 20:08
IF formulas
I would like to reference an IF formula to a specific cell. Similar to how a
VLOOKUP references a certain cell. Is this possible? I tried this;