View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
paul paul is offline
external usenet poster
 
Posts: 11
Default How do I move this data?

I have some excel data that I need to merge into one cell... for
example

ADDR1-ST Num ADDR1-ST Name
111 E MAIN ST


I want to put it all in one cell
ADDR1-ST Name
111 E MAIN ST

I have about 15,000 records so I want the [SPACE] between the Number
and the Name

any ideas?
thanks.