Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rows to columns
I'm writing here as I couldn't find any way of achieving what I need
using Excels built-in modules so probably the only way is through some code. I have a list of addresses that were imported to Excel and they are all in one column. I need to get them to be in multiple columns. E.g. I have 2 or 3 lines of one address in one cell so here I would need to get each line in a separate column which would give 3 columns with addresses and then underneath another cells with bits of address and so on . Hope it makes sense. Can someone help me with this please? yaro |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
rows to columns
Hi
No code needed. Look at "TextToColumns" on the Data menu. To use the function first select the column, then follow the instructions. Hopes this helps. --- Per "yaro137" skrev i meddelelsen ... I'm writing here as I couldn't find any way of achieving what I need using Excels built-in modules so probably the only way is through some code. I have a list of addresses that were imported to Excel and they are all in one column. I need to get them to be in multiple columns. E.g. I have 2 or 3 lines of one address in one cell so here I would need to get each line in a separate column which would give 3 columns with addresses and then underneath another cells with bits of address and so on . Hope it makes sense. Can someone help me with this please? yaro |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
rows to columns
On Mar 17, 10:20*am, "Per Jessen" wrote:
Hi No code needed. Look at "TextToColumns" on the Data menu. To use the function first select the column, then follow the instructions.. Hopes this helps. --- Per I tried that but it won't do what I need unless you know what's the code for end of line which I don't. yaro |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
rows to columns
Post an sample of your data, so we know what to deal with.
--- Per "yaro137" skrev i meddelelsen ... On Mar 17, 10:20 am, "Per Jessen" wrote: Hi No code needed. Look at "TextToColumns" on the Data menu. To use the function first select the column, then follow the instructions. Hopes this helps. --- Per I tried that but it won't do what I need unless you know what's the code for end of line which I don't. yaro |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
rows to columns
On Mar 17, 10:50*am, "Per Jessen" wrote:
Post an sample of your data, so we know what to deal with. --- Per Not sure how to post it here but I've got something that looks like this: ________A_______________ B ¦ The Long House ¦ 8 Cavendish Square ¦ Barnet ¦ _________________ ¦_______ ¦ 33 Kings Road ¦ High Road ¦ Putney ¦ _________________ ¦_______ ¦ 9 Sesame Street ¦ Kent ¦ _________________ ¦_____ ..... and I need this: _______A______________________B______________C____ ____ The Long House ¦ 8 Cavendish Square ¦ Barnet ¦ __________________________________________________ _____ 33 Kings Road ¦ High Road ¦ Putney ¦ __________________________________________________ _____ 9 Sesame Street ¦ Kent ¦ ¦ Hope it displays fine. Thanks yaro |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
rows to columns
Well it didn't display right. I'll try without lines so it should be:
A B C The Long House 8 Cavendish Square Barnet 33 Kings Road High Road Putney 9 Sesame Street Kent Hope this is clearer. yaro |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
rows to columns
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 "yaro137" skrev i meddelelsen ... Well it didn't display right. I'll try without lines so it should be: A B C The Long House 8 Cavendish Square Barnet 33 Kings Road High Road Putney 9 Sesame Street Kent Hope this is clearer. yaro |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make Excel see columns as rows and rows as columns | Excel Discussion (Misc queries) | |||
how do i paste rows/columns avoiding hidden rows/columns | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
how to interchange rows to columns & columns to rows in a table | Excel Discussion (Misc queries) |