This works great! Thank you for your assistance! Happy Friday!

"Max" wrote:

A little tinker to try ..
Copy A1:A500, paste into Notepad
Copy from Notepad, paste into formula bar for B1
Put in C1: =SUBSTITUTE(B1,CHAR(10),";")
Copy C1, paste into Notepad. Done in 10 sec
Success? celebrate it, hit the YES below
--
Max
Singapore
---
"Lisa L" wrote:
I am needing to combine a row of cells into one cell. Say, for example,
A1:A500 are all zip codes. How can I combine all the 500 zip codes into one
cell, separated by a semicolon?