Originally Posted by captnjack

concatenta formula is =A1&", "&B1 which puts a comma space between data in A1 and B1 so if a1 is doe and b1 is john you now have doe, john in whatever cell you entered the formula presumably c1. If you do not want to insert a comma space leave out the &", " after the A1. If you want to combine 3 columns its =A1&", "&B1&", "&C1 However this is a forumla and as such each row will be unquie until you convert it to text. The only way I know how to convert to text is copy, paste special, value. So you are still stuck with the copy command.