I concatinated 3 columns using this formula:
=D2 & ", " & E2 & ", " & G2
But I can't save my results in a text format. I get an error message saying "the data I'm pasting isn't the same size as my selection".
Any ideas why?
Thanks
Seamus
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
CONCATENATED 3 fields and can't save results
0
Discussion
What do you mean to save it in a text format? If you mean to convert the formulas into text, just select them and hit Ctrl + C and then Alt + E + S + V Enter.
don (rep: 1989) Apr 10, '19 at 7:32 am