udprocks Member Jan 16, 2015 #1 Hallo sir's. Is this possible "Extract data from one cell to seprate column's" Like i have attached sample file. Appericiate any help. Attachments 77_RAW_exa.xlsx 77_RAW_exa.xlsx 11.1 KB · Views: 7
Hallo sir's. Is this possible "Extract data from one cell to seprate column's" Like i have attached sample file. Appericiate any help.
Luke M Excel Ninja Staff member Jan 16, 2015 #2 With the cell selected, go to Data - Text to Columns. Select Delimited, and choose Space. This will split the text up into different columns, and you should be able to better analyze from there.
With the cell selected, go to Data - Text to Columns. Select Delimited, and choose Space. This will split the text up into different columns, and you should be able to better analyze from there.
shrivallabha Excel Ninja Jan 17, 2015 #3 And one row of data is not sufficient to understand the logic. Few more examples and some explanation would definitely help.
And one row of data is not sufficient to understand the logic. Few more examples and some explanation would definitely help.
