CONCATENATED 3 fields and can't save results

0

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

Answer
Discuss

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: 1685) Apr 10, '19 at 7:32 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login