View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mt engineer mt engineer is offline
external usenet poster
 
Posts: 1
Default Creating Columns from space delimited list

I have a list of distances and elevations from a certain point.

i.e. 8000 5230 7000 5231 6000 5233

That is about 500 numbers long. I would like to take the information and
split it into two columns.

i.e. 8000 5230
7000 5231
6000 5233

I have tried several ways of find and replace to no avail. Is there a VB
code to do this?