Solved

how to combine cells in excell

Posted on 2014-10-10
39 Views
in a spreadsheet how do I combine B2 with ":" and C2 to get

contents of B2: contents of C2
0
Question by:Matt Pinkston

LVL 40

Accepted Solution

Kyle Abrahams earned 167 total points
ID: 40374056
Use the Concatenate function

= Concatenate(B2, ":", C2)

Note you can use a space ": " if you need the space between.
0

LVL 27

Assisted Solution

Glenn Ray earned 167 total points
ID: 40374060
Alternatively, you can use the ampersand to concatenate:
=B2&":"&C2

-Glenn
0

LVL 25

Assisted Solution

ProfessorJimJam earned 166 total points
ID: 40374153
and ALTERNATIVELY  :-)
if you didn't bother with formula then here you use the below macro code to do it all at once

``````Sub joincells()
Dim myrange, mycell As Range
Set myrange = Sheets("sheet1").Range("B2", Range("B1047586").End(xlUp))
For Each mycell In myrange
mycell.Offset(0, 2) = mycell.Value & ":" & mycell.Offset(0, 1).Value
Next mycell
End Sub
``````
0

Featured Post

Suggested Solutions

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…