Forum Discussion
Text to column
I am having some data which is not arranged in the format which I want, in order to change it in to the format I was trying to change it to text to column. But unfortunately it is not giving the data how I want as the data are in different lines in the cell (Alt+Enter) . I presume that is the reason why it is not appearing. Could anyone help me how to rectify it easily.
I have put the data for reference below. If the excel file is required I can share it.
| 1.01 | LADDER CABLE TRAY: - MATERIAL:- FRP - INDIVIDUAL RUNG LOAD CAPACITY:- MINIMUM 90 KG - LOADING DEPTH:- 76.2 MM - WIDTH:- 100 MM -LENGTH:- 3660 MM -DEPTH-101.6 MM COMMODITY NO.: 6000000774 |
| 1.02 | LADDER CABLE TRAY COVER: - MATERIAL:- FRP - WIDTH:- 100 MM - THICKNESS- MINIMUM 1 MM - LENGTH:- 3660 MM - FLANGE TYPE:- OUTSIDE - COVER TYPE:- SOLID COMMODITY NO.: 6000000774 |
| 1.03 | LADDER CABLE TRAY COVER: - MATERIAL:- FRP - WIDTH:- 100 MM - THICKNESS- MINIMUM 1 MM - LENGTH:- 3660 MM - FLANGE TYPE:- OUTSIDE - COVER TYPE:- LOUVERED COMMODITY NO.: 6000000774 |
| 1.04 | LADDER CABLE TRAY: - MATERIAL:- FRP - INDIVIDUAL RUNG LOAD CAPACITY:- MINIMUM 90 KG - LOADING DEPTH:- 152.4 MM - WIDTH:- 150 MM - LENGTH:- 3660 MM COMMODITY NO.: 6000000774 |
| 1.05 | LADDER CABLE TRAY COVER: - MATERIAL:- FRP - WIDTH:- 150 MM - THICKNESS- MINIMUM 1 MM - LENGTH:- 3660 MM - FLANGE TYPE:- OUTSIDE - COVER TYPE:- SOLID COMMODITY NO.: 6000000774 |
| 1.06 | LADDER CABLE TRAY COVER: - MATERIAL:- FRP - WIDTH:- 150 MM - THICKNESS- MINIMUM 1 MM - LENGTH:- 3660 MM - FLANGE TYPE:- OUTSIDE - COVER TYPE:- LOUVERED COMMODITY NO.: 6000000774 |
| 1.07 | LADDER CABLE TRAY: - MATERIAL:- FRP - INDIVIDUAL RUNG LOAD CAPACITY:- MINIMUM 90 KG - LOADING DEPTH:- 152.4 MM - WIDTH:- 300 MM - LENGTH:- 3660 MM COMMODITY NO.: 6000000774 |
| 1.08 | LADDER CABLE TRAY COVER: - MATERIAL:- FRP - WIDTH:- 300 MM - THICKNESS- MINIMUM 1 MM - LENGTH:- 3660 MM - FLANGE TYPE:- OUTSIDE - COVER TYPE:- SOLID COMMODITY NO.: 6000000774 |
Select the second column.
On the Data tab of the ribbon, click Text to Columns.
Select Delimited, then click Next.
Tick the Other check box, click in the box next to it and press Ctrl+J
Ctrl+J is the line break character.
Click Finish.
1 Reply
Select the second column.
On the Data tab of the ribbon, click Text to Columns.
Select Delimited, then click Next.
Tick the Other check box, click in the box next to it and press Ctrl+J
Ctrl+J is the line break character.
Click Finish.