Seperate column
I have one column with the following information:
Last-name1 space Last-name2 space Name The names are of different lenghts. I have to seperate Last-name1, Last-name2 and Name and put them in seperate columns. So from one column I have to go to 3 columns. Please help. Thanks in advance. Hildo |
Seperate column
Hi
use 'Data - Text to columns' for this -- Regards Frank Kabel Frankfurt, Germany Hildo wrote: I have one column with the following information: Last-name1 space Last-name2 space Name The names are of different lenghts. I have to seperate Last-name1, Last-name2 and Name and put them in seperate columns. So from one column I have to go to 3 columns. Please help. Thanks in advance. Hildo |
Seperate column
Hildo
Try DataText to ColumnsDeleimited by space. Should work if you have just the three names in the cell(s). If more, like Van der Sander, Van der Meer, Hildo, you will have to do some juggling and possibly re-gluing after. Gord Dibben Excel MVP On Mon, 31 May 2004 15:52:34 -0700, "Hildo" wrote: I have one column with the following information: Last-name1 space Last-name2 space Name The names are of different lenghts. I have to seperate Last-name1, Last-name2 and Name and put them in seperate columns. So from one column I have to go to 3 columns. Please help. Thanks in advance. Hildo |
All times are GMT +1. The time now is 08:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com