Forum Discussion
An UDF for Concatenate Function
Hello I was wondering whether it is possible to achieve this result using VBA/UDF? https://ibb.co/2yn729f Basically what I wanted to do is to be able to concatenate various string fr...
aijatiw Yes, you can create a VBA function but my question is why complicate it that much?
You could easily just have a column C with the below formula:
="Student with name "&A2&" is now on year "&B2
You can drag this formula down as many rows as you need. No need to be "typing the formula over & over again".
I'm sorry I think that I make myself unclear, because what I want is instead of typing =C35&C31&C36&D27, I want it to type =result(C31,D27) and it show the same result, so I was thinking how to put the "student with name " and "is now in year " like embedded on the sheet? I'm sorry if this confuses you I hope you get what I'm trying to say.
Because I need it to become as dynamic as possible. I will be dealing with more column and the result is not only to concatenate a row then drag it down,
Because I need it to become as dynamic as possible. I will be dealing with more column and the result is not only to concatenate a row then drag it down,