How do you merge two columns?

[omegadeltaphi]

I have two columns and multiple rows.
A column has most of the info.....97%.
B column has little information and it is only a single letter.
I need to move that letter from column B to column A.
ex.

________________________________________
column:A column:B

info blank
info blank
info blank
status: "x"
_________________________________________

I want to merge Columns B and A
somethin like this
----------------------------------------------------
Column:A

status: x
----------------------------------------------------
ps sometimes status is "x", "y", or "xy"

 

[shadow12345]

In Col C you could put

(In C1 then copy down)
=a1&b1

Then just copy paste special values over the top of Col A

 

[omegadeltaphi]

thx shadow

 

[Rick Rothstein]

This macro should do what you asked for...

Sub CombineStatus()
  Dim Cell As Range
  For Each Cell In Columns("B").SpecialCells(xlCellTypeConstants)
    Cell.Offset(, -1).Value = Cell.Offset(, -1).Value & " " & Cell.Value
    Cell.Clear
  Next
End Sub

 

[omegadeltaphi]

Rick
you have been so helpful today
thank you so much

I just found this website today and Im diggin it
Really


thx

a mil