Select data and paste in single cell

Closed
mary - May 7, 2009 at 06:05 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 11, 2009 at 02:01 AM
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 response

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
May 11, 2009 at 02:01 AM
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" .......


0