Thread: rows to columns
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
yaro137 yaro137 is offline
external usenet poster
 
Posts: 6
Default rows to columns

On Mar 17, 2:17*pm, "Per Jessen" wrote:
Hi

As there are no delemitters in the string we have to insert some.

Select the cells, goto Edit Find Find what: " *" (enter two spaces)
Replace Replace with ", " Replace All.

Now use TextToColumns with the comma as delemiter"

Hopes this helps

---
Per



It works all right with one space but not with 2 or more. Thanks
yaro