i've put this previously on here with no results. There is a formula already in there though does not work because what I want to achieve is to have Column A & Column C to Match Column E & Column F, to Return the Value YES or NO. I’ve Highlighted in ROW 947 one that should Say NO yet Says YES.
View 3 Repliesi need to copy the values from more than one cell and need to paste all the values in the single cell (if possible values seperated by commas).
View 2 Replies View RelatedI'm writing an Excel Macro and want to sum a number cell with the value "45667" and a text cell with the value "Prague" and return it to a new cell with the value " 45667 Prague"
I've done it successfully with the two text cells "John" and "Hopkins" to "John Hopkins".
This is my
Sub SumCells()
Dim FirstName, SecondName, Zipcode, City, fullname, fulladdres, space
FirstName = range("cell1").value
SecondName = range("cell2").value
Zipcode = range("cell3").value
City = range("cell4").value
space = " "
fullname = firstname + space + secondname
fulladdress = zipcode + space + city
The problem is that city is recognized as "Prague", and the zipcode as 45667 (without the "")
I have a list containing hundreds of rows and I need to join the cells in different columns.
Eg. Col A, Row 1 is "Red Maple"
Col B, Row 1 is "Acer Rubrum"
Col C, Row 1 is "60mm"
I need to join the row into one cell reading "Red Maple Acer Rubrum 60mm"
I want to take a cell with a persons first name and a cell with their last name and combine into one.
EX.
What I have.
A1 B1
John Smith
Walt Smith
What I want.
A1
John Smith
Walt Smith
I have a column with numbers in each cell. I need to add the same three letters before each of the numbers. Example:
number in cell: 25067 I need it: ABC25067
I did a macro for it but had to do each one individually. I imagine there is a simple formula to do this automatically but I don't know enough to figure it out (despite reading up on it for the last hour!)
I have a sentence in field A1 and a number in field A2. The formula I am using is =A1 & A2. This is working but there is no space in between A1 and A2. How can I add a space?
View 2 Replies View RelatedI am trying to append data in let's say column A:A with the variable text in J:J. The data in column A:A will look like this /dir/dir/dir/<from this point is where I need the data appended>.
View 4 Replies View RelatedI have a document that has 3 colums.
Complete Name | Surname | First Name
The Complete Name is currently blank. The others just list the users Surname and First name. In the Complete name I need it to have Surname,Firstname - for example
Complete Name | Surname | First Name
Jordan,Michael Jordan Michael
Is there a Formula (Not Macro) that I can use to combine the Surname and First name cells to populate the Complete name cell with the surname,first name???
I am trying to write some VBA to join the values in 2 cells into another cell for a list, however my knowledge at this level is a little lacking. For each row in a list I would like to join the value of the cell of Column A and the value in the cell of Column B and write the output to Column C for that row, as shown in the attached example. Column C in the example shows the expected output.
View 4 Replies View RelatedI'm trying to merge two cells, But i want the second cell to be merged without the last 6 characters, im joining a file, wich is easy to understand. =(A2 & " " & A3) I want A3 without the last 6 digits, I know i have to use the RIGHT function but how so??
View 3 Replies View RelatedI have a marco that works perfects to Concatenate (join) all of the cells in Column A. However, I want to seperately join all of the cells in each column. So I wanted to the Concatenate of Column B to go in B1, Column C to go in C1, etc (or until there is no data in a column). I think there is a way to change this into a loop, but I don't know how. Below is the macro I have now.
Sub ConcatenateAll()
Dim x As String, rng As Range, cel As Range
With ActiveSheet
Set rng = .Range("A2:A300")
For Each cel In rng
x = x & cel.Value
Next
.Range("A1").Value = x
End With
End Sub
i know this is easy but i don't have an idea how to do it. I have dates written on column A1:A7 like
29-Mar-09
30-Mar-09
31-Mar-09
1-Apr-09
2-Apr-09
3-Apr-09
4-Apr-09
what I would like to do is how can I combine 29-Mar-09 and 4-Apr-09 into one cell...I would like the output to be placed in cell A8 appear as "29-Mar-09 to 4-Apr-09".
I am trying to join text in two different cells using concatenate function / & operator In the combined cell I want the text from second cell to appear in Bold while the text from first cell should continue to remain in normal font. Is there any way i could achieve this?
View 4 Replies View RelatedI have a number in A1, another number in B1, a Date in C1. In D1, I am referencing all 3 of the other cells: =CellA1 & "-" & CellB1 & "----" & CellC1. Trouble is the date is coming through as a number. Is there a way that I can get the date to show as displayed as opposed to the value of the cell?
View 2 Replies View RelatedI'm have a list of keywords from google adwords:
cabinet hardware
cabinet hardware knobs
cabinet hardware pulls
kitchen cabinet hardware
amerock cabinet hardware
antique cabinet hardware
These are all in A1, B1, C1, D1, E1, F1
I need to have them look like this: A1 cabinet hardware, cabinet hardware knobs, cabinet hardware pulls, kitchen cabinet hardware, amerock cabinet hardware, antique cabinet hardware. How do I do it? Im a COMPLETE Newbie when it comes to excell but I urgently need to figure this one out....how do I do it?
how to copy the content of cells of different xcell files from a given directory into a single formatted xcell sheet.
View 9 Replies View RelatedI am currently working with a team of people who are on connected to different networks, and frequently coming on and off the project. We hold a spreadsheet with everyones details, and some of these details are the mailing lists each person should be subscribed to. For example "System Downtime","Team Leads" etc.
As people come and go, we dont want them recieving emails when they are not on the project.
Attached is a greatly cut down version of what we have. For most users the data will be locked down - we want them to be able to copy the mailing lists to their clipboard via a dashboard so they can then paste it into their Outlook.
Pseudo
On clicking "Copy to your clipboard"
Lookup mailing list selected in drop down (This dropdown validates on the MailingList range D2:I2)
Look for the corresponding column for that mailing list
Only look at rows where the individual is on the project ("Yes")
For each person with "Yes" in the column for that list, concatenate their email address
Copy the result to the users clipboard, ready for them to paste into the To: field in their browser
I have 2 columns which contain numbers that have laeding zeros. example:
Column H has 002345 and Column I has 0678. I have tried H1&I1 but the leading zeros are stripped off. Is there a way to combine 2 cells AND preserve the leading zeros in both cells ?
I am using this formula to combine Excel Dates & Times which is in seperate cells.
day Month Year Time
=B13&"/"&C13&"/"&D13&F13
and trying to convert to Numerical Time for further calculations.
I have tried many Format variations but nothing seems to work.
It will show the correct Numeric Time if the Formula: =NOW() is used in Cell K12
But it won't show the same from the imported data that is Text format
in Cell I 12
The sample W. Book shows a better explanation of the problem.
The end result is to show how much time has lapsed in Cell M 14 by converting Time to Numerical and simply do the sums. Works otherwise but not in this instance.
The reason to trigger various macros according to pre-set Time Limits Etc.
I am trying to find a way to create a macro that will take the data selected from the combo box and concatenate it with the data found in cells.
For Example:
Combo Box Selection - "Test"
ID (Column A) - Before
12345
98765
99999
55555
empty cell
23232
ID (Column A) - After
12345 Test
98765 Test
99999 Test
55555 Test
empty cell
23232
For Exempel
A1=B
A2=1
A3="="&A1&A2
I have even tried with concernate and indirect in A3 but no difference there...
I want A3 to return =B1 but it only returns it in text but i want it in form of a formula. Is there a formula that returns text directly into a formula or an easy way to do this?
I have two sets of data to compare. One is real world data, the other is forecasted data. I have real daily data for every day over about 3 months. The predictions though, there may be 4-6 predictions for ever one real daily value.
What I'd like to do is have a function that looks at Column A's date (real daily value) and Column C's date (predicted data) and if Column C equals Column A, then divide corresponding data in Column B by value in Column D.
I have four different cell.
Cell a1 contains 6 digits
Cell a2 contains 1 digit
Cell a3 contains 6 digits
Cell a4 contains 4 digits.
Cells a3 and a4 may contain a number less than number of digits specified above but are custom formatted 000000 and 0000 respectively to ensure they have the correct number of digits. My problem is when I try to combine the four cells they lose their formatting. I have tried =A1&A2&A3&A4 and = concatenate(A1,A2,A3,A4). But both formulas loose the formatting from the individual cells.
I am trying to write a macro that will select and copy all cells in a row that do not have a zero value.
The data I am trying to select will be contained in 12 cells in a single row, i.e cells A1:L1 and all zero values will always be on the right hand side of the first non-zero value in this row (going left to right), for example:
Row: A B C D E F G H I J K L
(1) 0 0 0 0 1 1 2 2 2 2 2 2
What I want to do here is to select and copy cells E1 to L1, since they are the cells with non-zero values. This can vary, so here there are 8 cells with non-zero values but the next time there might be only 5 cell or all 12 cells, etc. I have a lot of data to sort like this so doing this manually takes a lot of time.
Once the macro has selected and copied the right cells, I will manually paste the data where I need to put it.
The big problem I am having is knowing how to firstly select the appropiate cells.
I am trying to use the ARRAY.JOIN function as recommended by Domenic in previous posts. I need to output a single column of values from a 10 x 10 grid that does not have values in every cell.
(I would also like to eliminate any blank cells from the final column.)
I can only get ARRAY.JOIN to output the first value of whatever range I select, not a column of values.
I am trying to use the ARRAY.JOIN function as recommended by Domenic in previous posts. I need to output a single column of all the values from a 10 x 10 array that does not have values in every cell. (I would also like to eliminate any blank cells from the final column.) I can only get ARRAY.JOIN to output the first value of whatever range I select, not a column of values.
how to properly execute that function. One earlier comment was that I was not specifying criteria. I'm not sure from the description and help section of "morefunc" as to what those criteria specs are, other than specifying the whole array. I am attaching a test file with the 10x10 grid & some missing values in A1:J10. Cell L1 has the ARRAY.JOIN function with the entire grid specified, but the output is only the first cell of the grid.
I am attemping to transpose a column of data into a single cell. I have a list of contact information, and one of the columns is for e-mail addresses. There are filters to the right of the data with different categories so the contact information can be filtered according to the different criteria. Ultimately, the people using the spreadsheet want to use those filters to create a list of e-mail addresses to send their distributions to.
The people who are using this don't have Outlook so we can't use an output to add them to the Outlook address book. We would like to make one cell at the bottom of all the data which would include all the e-mail addresses from that column seperated with a semi colon so they can just copy the contents of that cell and paste that into the To: field on their e-mail program. I've tried several different things but I've not been able to find a solution.
I have a spradsheet that I've formatted using merged cells. The spreadsheet has several columns. Into these columns I must enter raw data extracted from our SAP data base. The extraction worksheet has no merged cells. So bottom line, I have a column of say, 30 non-merged cells and I want to paste that column into my formatted spreadsheet that has 30 merged cells of thre cells a piece (90 cells total).
So far I have been unable to do this. If I've attached it correctly, the sample attached
MERGE EXAMPLE.xls‎
Looking for formula with if then statement that involves a nested formula or concatenation. I need a formula that says: If cell A reads exactly ABCD then concatenate cell A with cell C. Very basic to most of you gurus but I'm fairly new with formulas.
View 3 Replies View Related