Combine/Join 2 Cells Into 1 Cell

Aug 23, 2006

I 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???

View 8 Replies


ADVERTISEMENT

Combine/Join Cells & Preserve Leading Zeros

Sep 6, 2006

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 ?

View 3 Replies View Related

Vba To Join Values In 2 Cells Into Another Cell

Sep 28, 2006

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 Related

Join Text From Multiple Cells To One Cell

Apr 27, 2009

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".

View 4 Replies View Related

Join Multiple Cells Into Single Cell

Jun 19, 2008

i 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 Related

Join 2 Cells & Show Equal Sign In Cell

Jan 17, 2008

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?

View 3 Replies View Related

Macro To Combine Cells In A Row To 1 Cell While Skipping Blank Cells

Jul 2, 2014

I need to combined all non blank cells in a given row into 1 cell. But within each row i have 5 phases that the values fall into, which is denoted by the 1st charter 1, 2, 3, 4, or 5. for example, in a given row i have 1-a, 1-c, 2-d, and 1-f and these values occurs in non consecutive columns starting from G to ALR. I need a macro that sorts these values in one of the 5 phases. So in another sheet the macro would combined [1-a 1-c 1-f] in Phase 1 and [2-d] in phase 2. and if there are other phases it would put them in the appropriate cell.

See attached workbook : Work Order Summary Sheet.xlsx‎

View 3 Replies View Related

Macro To Combine Cells In Row To 1 Cell While Skipping Blank Cells

Jul 17, 2014

However, in addition to what the macro already does, it is possible to add another work sheet in the same work book that outputs the values in separate cells? It also has to output the data in order: for example, in the first work sheet the data is inputted at random and has spaces but the macro will have to remove all the blank cells and output them in order based on the first value in the test string, 1, 2, 3, 4, and then 5;

input:

blank 3-x Blank 1-y blank 2-z 1-k

output:

1-k 1-x 2-z 3-y

View 4 Replies View Related

Macro To Combine Several Cells Into One Cell

Jun 8, 2014

Creating a macro that is a combination of other cell values. the cell order is listed below:

C57 = contains a unique number that will change from time to time eg. 1234
H57 = 1 (this will always be the value of 1)
N57 = contains text eg. AUDUSD
V57 = contains text eg. BS
AB57 = contains a number eg. 1.8954
AH57 = 0 (this will always be the value of 0)
AN57 = contains a number eg. 0.01
AS57 = contains a number eg. 1.7954
AZ57 = contains a number eg. 1.9954
BH57 = conatins either 1 or 0 eg. 1

the cell needs to contain the above examples like this :
BT57 =OpenPosition(1234,1,"AUDUSD","BS",1.8954/0,0,0.01,1.7954,1.9954,1)

This will be needed for a total of 14 rows (57, 59, 61, 63, 65, 67, 69, 71, 73, 75, 77, 79, 81, 83)

The cell with the results cannot have any cell references contained in the end results and must be formatted as above so that the add in program can read and pass on the information.

View 3 Replies View Related

Combine Data From 2 Cells Into 1 Cell

Mar 13, 2013

Let's say there is a name (Big Bird) in cell A1

Let's also say that cell B1 has =Today()

How can I make cell C1 = Big Bird 3/13/2013?

View 9 Replies View Related

Combine Text From Many Cells Into One Cell

Apr 15, 2009

Column A has the following values:

au:asd
au:qwe
au:zxc
etc

I want to combine the text from each cell into a text string so that each cell's text is separated by a comma, thus:

au:asd,au:qwe,au:zxc,etc

I can do this with a formula,
=a1&","&a2&","&a3
but this may exceed the 255 character limit when the text string needs to be transferred to a query.

View 9 Replies View Related

Combine Data From Diff Cells Into One Cell

Aug 27, 2009

I have 5 columns, each with some data. On the 6th column I need to combine the data from all 5 columns into column 6 to be as: Data in A2-Data in B2-Data in C2-Data in D2-Data in E2. With one exception. column D is the date in this format 27-Aug-09. I need the date to be modified on the fly from 27-Aug-09 to be 270809 which will be the info in D2. See example attached.

View 3 Replies View Related

Merge And Combine Data In 2 Cells To One Cell?

Jun 21, 2013

I need a macro, that will merge the cells and the data in cell A1 with data in B1, and the data in cell B1 will paste to the end of data in cell A1.

Column A Column B
KL8CB6S90DC505233
3GYT4MEF9DG331323

I need the final result to look like this:

Column A
KL8CB6S90DC505233
3GYT4MEF9DG331323

I need it to complete this for all data in Column A and Column B.

View 3 Replies View Related

How To Combine Cell Data From Many Cells In A Column

Mar 3, 2014

21045

21022

21054

20214

20114

I would like to know how to combine many cells in a column - sometimes 100's - into one cell separated by a comma without having to type each cell name using.

View 4 Replies View Related

Join 2 Cells In VBA

Dec 6, 2007

I'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 "")

View 3 Replies View Related

Find Duplicates / Triplicates Or More And Combine Cell Value Of Next Cells

Aug 12, 2014

I want a VBA that searches for duplicates, triplicates, or more and combine the cellvalue that is next to the duplicates. Also, if it combines them, it should only use the last letter. I have a code that works partially, but I'm stuck.

For example, I have this list:

1
2014A

2
2014B

3
2014C

1
2014D

4
2014E

1
2014F

I want it to combine the A, D and F like this:

1
2014A

1
A/D/F

2
2014B

[Code] .......

I created the following script, but i can't get it to use the last letter. Also it creates a " / / " when the cells are empty.

View 2 Replies View Related

Combine Multiple Cells Into One Cell With VBA Code And Repeat Until Last Row?

Aug 26, 2013

I am using the code below to combine the rang of cell values into 1 cell. with this code I need to select the range of cells manually and run the code then repeat it on the next row manually.

What I need is automatically find the range from selected cell till last cell in the row and run the cod for this range then do the same on next row until last row of the sheet.

Code:
Sub JoinAndMerge()
Dim outputText As String[code]....

View 1 Replies View Related

Join Cells & Compare To Single Cells

Jul 5, 2007

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. Ive Highlighted in ROW 947 one that should Say NO yet Says YES.

View 3 Replies View Related

How To Join Cells In Different Columns

May 31, 2012

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"

View 2 Replies View Related

Join Two Cells Of Data

Apr 20, 2009

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

View 9 Replies View Related

Join Text To Cells

Jan 10, 2007

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!)

View 9 Replies View Related

Join Cells With Space

Aug 7, 2007

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 Related

How To Retain Leading Zeros In A Cell When Combine The Values Of Two Cells?

Oct 25, 2012

I have managed to retain leading zeros in a cell by formatting the cell and selecting Number and Custom and adding the maximum number of zeros I want to have in front of the number in the cell i.e. 000002.

I want to have another cell in the spread sheet which contains the value 35394000002 using the formula =A24&B24.

When I use this formula I get 353942. How can I retain these zeros?

View 1 Replies View Related

Combine Multiple Cells To Create Unique Cell Value In A Column

Sep 23, 2012

I would like to know how to combine multiple cell value from each column to create a unique value. for example column A will have values (a,a,b,c,d,e,e,f,i,j) and B will have (1,2,1,1,3,4,5,5,6,7) and C has ( xxx,yyy,zzz,xxx,yyy,zzz,xxx,xxx,yyy,zzz).

i need to create a list of unique possible combination of data into column D.

I have placed below example and how to create a similar code and what functionality does this.

A
A Code
B
B Code
C
C Code
D
D Code

[code]...

View 5 Replies View Related

Join Text From Adjacent Cells

Oct 21, 2009

I 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 Related

Join 2 Cells Omitting Last X Characters

Jul 28, 2007

I'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 Related

Concatenate (Join) Cells Across Columns

Feb 9, 2008

I 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

View 2 Replies View Related

Join Text In Two Different Cells Using Concatenate Function?

Nov 19, 2013

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 Related

Join Cells & Retain Date Formatting

Nov 30, 2007

I 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 Related

Join Several Cells & Seperate With Commas And Spaces

Jan 24, 2008

I'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?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved