I have a problem where I want to read a range like, A1:F1 and then write that data into column A only, so A1-A6.
I feel like it should be fairly easy to do but I have been scratching my head trying to solve this problem for longer that I care to admit.
If someone could please help and enlighten me, that would be great!
I used the string manipulation example and it works like a charm!
If it is not too much to ask, how does it work and how can I learn more about it? Looking at System.Text.RegularExpressions.Regex.Replace(text,β^.*\nβ,ββ).Replace(β,β,vbcrlf) does not really say anything to me but I would like to learn more so I understand what is going on.
Thank you once again for the quick and informative response.
It is still a bit confusing but I think I am catching on. The only thing I would like to know a bit more about is how and what Regex is used and knowing what symbols to use, but I may be able to find the material of that on my own.
Thank you for the explanation and help once again!