Concatenate

[rubinda]

I have never written a concatenate code in VBA before and I am not finding anything.

I am trying to convert the following formula to VBA: =CONCATENATE("MD",MID(A4,4,1),RIGHT(A4,5),G4)

Can you please help?

 

[Rick Rothstein]

Give this a try...

[table="width: 500"]
[tr]
	[td]ConcatValue = "MD" & Mid(Range("A4").Value, 4, 1) & Right(Range("A4").Value, 5) & Range("G4").Value[/td]
[/tr]
[/table]

 

[rubinda]

Thank you. How would I get that to look down all of column C all the time?

 

[Rick Rothstein]

Thank you. How would I get that to look down all of column C all the time?

I am not sure what you mean by that. Can you describe what you want in more detail please?

 

[rubinda]

I am trying to find code that will look for text in column B. If there is data in column B, I would like code to use concatenate to fill that in in column C. I do not want to use a formula, just code.
Does that make sense?

 

[Rick Rothstein]

I am trying to find code that will look for text in column B. If there is data in column B, I would like code to use concatenate to fill that in in column C. I do not want to use a formula, just code.

Some follow up questions...

1) Is your data contiguous in Column B or could there be blank cells scattered about between the data cells?

2) Did you want every data cell concatenated together and placed into a single cell? If so, which cell? If not, please explain exactly what you do want.

3) What row does your data start on?