Hello my learned friends in the excel forum. I am looking for a way to take 2 columns and combine them into one coumn, sort of the opposite of the text to columns function. In my attached example, I start with a sample 3 row spreadsheet with 2 columns. The first column is the filename, and the second column is the file extension. I want to use a formula or something to change these 3 rows and 2 columns to just 3 rows and one column, as illustrated in the second excel attachment. Is there a way to do this? Many thanks

Attached Files

	initial excel sheet sample for excel forum.xlsx (9.1 KB, 4 views)
	expected excel spreadhseet output.xlsx (9.0 KB, 4 views)

Try the CONCATENATE function or the & operator

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Yes, that works perfectly for what I want to do, thanks for that

You're welcome

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post