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
|