Home » POI projects

How Do I Merge Cells In Microsoft Excel For A POI File?

 
Sun, 09/14/2025 - 11:21am

I am working on a new POI file for Minnesota Amateur Radio Repeaters. I have it in Microsoft Excel spreadsheet with Column A and Column B listing the LON and LAT. I think that part of it is fine.

I want the data from Column C and Column D in the same Column. I think there is a way to do it. I have Googled this and tried a few different methods, but I cannot seem to get it quite right. Does anybody on here know how I can take that data and place it in the same column?

‹ When I Create A Custom POI File, What is The Limit To The Number Of Characters That Can Display On The Screen? Planet Fitness project discussion ›
Sun, 09/14/2025 - 11:41am

https://support.microsoft.com

https://support.microsoft.com/en-us/office/combine-text-from...

?

Sun, 09/14/2025 - 1:59pm

text

type into cell e1 =concatenate(c1," ",d1)
copy cell e1, paste all the way down to the last row
copy column e
right click "paste special" "values" to cell c1
delete column d & e

--
the title of my autiobiography "Mistakes have been made"
Sun, 09/14/2025 - 8:15pm

How Do I Merge Cells In Microsoft Excel For A POI File?

I did finally get this going.

Thank you!