I have two cells A1 with value "A" and B1 with value "B".
How do i get cell B1 to end up with the value "AB",

I have tried concatanate but that need a third cell, are there any
other ways to do this...


gaz

Ok, say you have a 1 in Cell A1. Type this in cell B1: ="ryan"&A1
The thing between the quotes is a String; Excel recognizes that as a series
of letters.

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Garry" wrote:

I have two cells A1 with value "A" and B1 with value "B".
How do i get cell B1 to end up with the value "AB",

I have tried concatanate but that need a third cell, are there any
other ways to do this...


gaz

Assuming your entry in B1 is not a static text string (as Ryan's formula
would require), you can use this macro to do what you want...

Sub CombineCellToLeft()
Dim R As Range
For Each R In Selection
R.Value = R.Offset(, -1).Value & R.Value
Next
End Sub

Then just select the right-hand cell (or cells) and run the macro... the
cell to the left of the selected cell (or cells) will be combined with the
selected cell (or cells).

--
Rick (MVP - Excel)


"Garry" wrote in message
...
I have two cells A1 with value "A" and B1 with value "B".
How do i get cell B1 to end up with the value "AB",

I have tried concatanate but that need a third cell, are there any
other ways to do this...


gaz