Select data and paste in single cell

[Closed]
Report
-
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,

Can any one please provide me with macro such that depending upon the data of Coloum A ,it should select the data in Coloumn B and Concatenate and paste in a cell in Coloum C with a space between each String.
please help me

1 reply

Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
155
I don't know why you are asking for macro ????? Your question is not clear you are depending on col A then Select Data B and paste in C ...

I think you can write formula in C as

=If(A1="good","Good"&" "&B1,"")

and drag it down ...

Suppose in A1 you have good and in column B mark ... then result will be as "Good 50" .......