I am working with a column which always displays the cell contents with oldest notes by date first, then the newest note last. I would like to have the contents from a cell reversed with the newest user input by date on top which will simply when reading. Here is an example of a cell. The string always starts with (MM/DD/YYYY TT:TT:TT AM, then user name).
12/20/2007 8:27:56 AM MBARNEY Approval not required for this change request. 01/25/2008 10:27:32 AM KVELDANDA Change to Category, Type, Item, Region, Site, Department fields triggered an evaluation of whether or not the Change requires approval. Approval is not required.
I have a bunch of rows that overlap other cells after using the format painter. My workaround has been to drag the row down to reveal the cell values. What's a better way to highlight many rows and do this in one shot? Adjusting each row to reveal text isn't efficient. I would like to not use macros either to solve this problem.
I have an Excel chart graphing two data records. As the data points cross, one is in "back" and one is in "front". I would like to reverse the current layout. Is this possible?
I am trying to do, is paste a word in front of text that is already residing in cell throughout an entire column, and then automate this process by creating a macro that will do the same thing for me throughout an entire column. To best explain this, it woudl be like if you have a column 100 rows/cells long, and every cell already contains data. I need to insert something in front of what lies within each cell.
I am trying to write a formula to reverse data in a cell. Basically I am converting a number to hex then I want to take that hex string and reverse it. So it would be something like this my original number is 400001001 my hex number would be 17D787E9 because I am only allowing it to show 8 characters. I want to reverse the 17D787E9 to read 9E787D71.
My question is: How can I reverse that cell? I have searched google and this forum and can't seem to figure it out. I am sure I could do it in VB but I don't know any VB code.
I can't seem to make user-defined format that puts a text in front of a number and/or a text.
Let's say I have A1: 13, A2: texttext A3: text7 and I want to format a lot of cells to "Ilike 13" / "Ilike texttext" / "Ilike text7"... ie add the same text in the front of the cell, no matter what the content is.
I did manage it seperately, with "texttext" @ for text and "texttext" # for numbers, but what's the general one?
ans....>and Good evening. I would like some helps about how to use sumif or any formula that can sum my credit. For example code------credits a12345------1 *b12345-----2 c12345-------1.5 *d12345-----3 The answer is 5 I would like to sum the credits only * infront of them.
I work as a data administrator in a high school in England. I've only been doing the job for about 8 months but a lot of the processes we go through could be better automated via the use of macros in Excel and Word.
Basically we have school grade reports that come from our MIS database that are stored as a Word template, which are then exported into Word as an .xml file. However, they don't come with the photographs of the students on the reports, so we have a Word List Report with every student photo (split into year groups) and run the following macro, which allows you to pick a folder where the reports are stored and match the photo to the report via the school admission number. It is then inserted into the report using a Word bookmark to place it in the top left corner.
VB: Sub InsertPhoto() Dim myFile, myFileNewName As String Dim PathToUse As String [code]....
This works fine but I would like to be able to automatically format the photos so that they have 'In Front Of Text' wrapping, which we need to keep the templates from messing up. It would also save me accessing nearly 1000 school reports and manually editing each photo.
On my graph the bottem axis shows 1-30, I'd like to change this to 30-1 as I track change over the last 30 days. I tried selecting reverse axis but it reverse's the data as well. Is it possible to change the axis text only, eg latest entry will be one and the 30 day old data will be 30.
There are basically four fields of text (date, trans. #, merchant, $ amount) all in one cell that I would like to have in 4 separate columns without having to cut-paste, cut-paste, cut-paste. Is it possible for me to break this information up quickly into 4 separtate columns? I have about 400 lines of text like this and would like to find a faster way to do it.
I am trying to select and move text from one column to another. I have roughly 1,000 cells in column A and I would like to tell Excel to select characters at certain positions and move them into the adjacent column.
I want it to look like this...
column A column B ABCDEFGHI BCI
Each cell in column A has a 9-letter sequence. I would like to move characters 2,3 and 9 into the adjacent column
It's difficult to explain, the attached shows the situation better. Basically there's a picture that is somehow linked to a cell. But, you can update the picture or the cell and the other one gets updated.
I have a formula that looks at a cell on a front sheet, and then returns the contents of that cell as the result if it meets the criteria. So for example this formula would be in Cell A1 on Sheet2 IF(SHEET1!A1,"New",Sheet1!A1,"-")
This formula is always in the same cell (different sheet) as the cell that it is looking at, down 1500 rows. Instead of having the formula named for each cell is there anyway to ask excel to 'look at this cell but on this other sheet'. e.g IF(Sheet1!"This Cell" etc). That way no matter what cell you put the formula in it is always referencing the correct cell for the formula?
I need to add an extra four zeros to a number in a cell - in this case an ID number, so that i can do a lookup from another list. Basically what i have is two lists of ID numbers in a field of a database, in one i have the correct display/format, so that a number would look like 000054454545. In the second list however the number is only shown as 54454545, due to differences in the programs which imported them. I would like to know if its possible to use a function or macro in excel to basically insert the four zeros onto the number ie 0000 + 54454545 = 000054454545 so that i can do a lookup of one for the other.
I have attached an Excel spreadsheet and I will apologize now if I lose you. This spreadsheet contains two entries:
"SwapIt" works great but will only reverse the most current date entry and list it first in the cell and the remaining date entries will remain in oldest to latest dates.
"ReverseDates" works great but errors out with <subscript out of range> when a manual date is entered in the notes (see system created format).
System created format; the entries within a cell will always be - MM/DD/YYYY_tt:tt:tt_AM(PM)_username (this varies) followed by the notes entered by user. So in a nutshell, the system will generate all the following but from oldest dates to latest dates toward the bottom of the cell. I would like to achieve the reverse order, latest entries to oldest entries.
I'd like to take the value from one cel, and reverse the digit order in another cell. Example cell c11 value is 1234, I want to display that value in cell c12 as 4321. Is there a way to do this?
I have a large table with data to which I want to retrieve a name to the left of a certain cell. Clear as mud so far!
I've put together a small example of what I'm after. In cell F9 is the MAX of cells F2:F7. In cell H3 I then want a formula that will find the MAX of F2:F7 and return the text five rows to the left of that cell. In this example it would be Fred.
The second part of this question is how could I get it to display if more than one person had the same total....
All of the information is provided in one cell, which I can not change. If possible I would like to pull the names from the middle only (example: cell d11 only give me Adam Diaz and so on). Once I have pulled out the name, I would to reverse the name (example: Diaz Adam).
d11=ADIAZ01 Adam Diaz (adam.diaz) d12=AELIZO02 Alejos Elizondo (alejos.elizondo) d13=BDELUN00 Bobby Deluna (bobby.deluna) d14=BFOREM00 Bud Foreman (bud.foreman) d15=BGREGG00 Billy Gregg (billy.gregg1) d16=CGREEN06 Christopher Greenwood (christopher.greenwood) d17=CGREEN08 Cheryl Green (cheryl.l.green) d18=DDOWNS01 Dickie Downs (dickie.r.downs) d19=DFLORE03 Daniel Flores (daniel.flores3) d20=DMENDE01 Donald Mendez (donald.mendez) d21=DMORAL01 David Morales (david.morales4) d22=DRODRI07 Domingo Rodriguez (domingo.rodriguez) d23=DWASHA00 Daniel Washa (daniel.washa) d24=EBROOK02 Earl Brooks (earl.brooks1) d25=ECARRE00 Edelmira Carreon (edelmira.carreon)
I am using Excel 2003. Looking for a way to find out whether some data I want to delete in a sheet is used by a formula somewhere else within the file. Is there a way to check that? In other words, I have the number 500 in A1, and I want to delete it, but I don't know whether it will impact a calculation on another sheet that involves that value in A1.
I am making a checklist for a Pda program. I need the active cell to highlight green and put an x in it for a specified range. This I have
The next part I cannot figure out - after the cell have been highlighted once, and properly colored with an x, how can I get it to delete the fill and clear the x on the next click.
Dim x As Long Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) ' Set the highlighted cell to a color. If Not Intersect(Target, Range("d28:d34")) Is Nothing Then Target.Interior.ColorIndex = 4 ' green = true 'Set the highlighted cell to contain a text character If Not Intersect(Target, Range("d28:d34")) Is Nothing Then ActiveCell = "x" End If End If End Sub
i have copied and paste text and numbers from a file into EXCEL. Now in one column i have the header and 4 lines, ie Header: Details Line 1: Email :* Line 2: Tel : *( )* Line 3: Fax :*( )* Line 4: Web address :*
I want to move Line 1 to 4 into different colums for sorting and pivot reasons.
I inherited a spreadsheet from someone who knows nothing of excel, its massive and I'm trying to organize it into an actual spreadsheet instead of some weird note taking program.
Is there an easy way to take a couple of Cells worth of text and move into one cell combined.
I.e.
This is just one Example
Above would be one example, there are 3 cells used to input one sentence... I want to move those to one cell to read
This is just one example
There are also cells with Data Separated by a "/" is there a way to separate that quickly without manually typing or reformatting my wrists are starting to hurt
I have an Excel sheet with several columns of data, each containing the link to a website. To the far right of this data, I have a column called "Official Source" in which I'd like to copy over any website links containing the phrase "sec.gov" (if there are any, if not than leave the cell blank).
For example, if I have the following data in my sheet:
Column A Column B Column C [URL].... [URL].... sec.gov/Ar
Than I would want the last source to move to column D -
Column A Column B Column C Column D [URL].... [URL].... sec.gov/Ar
