Question

A B 2 1 ld 21 3 M IN L Doors Lowercase Sentence 3 3 4. 3 بیب 32 بیب 7 8 بیب بیب 9 10 بیب بیب 12 بیب 13 بیب C D E F Price Age_08_04 Mfg_Year KM 13500 23 200246986 13750 23 2002 72937 13950 24 2002 41711 14950 26 2002 48000 13750 30 2002 38500 12950 2002 61000 16900 27 2002 94612 18600 30 2002 75889 21500 27 2002 19700 12950 23 2002 71138 20950 25 2002 31461 19950 22 2002 43610 19600 25 2002 32189 21500 31 2002 23000 22500 2002 34131 22000 28 2002 18739 22750 30 2002 34000 17950 24 2002 21716 16750 24 2002 25563 16950 30 2002 64359 15950 30 2002 67660 16950 29 2002 43905 15950 28 2002 56349 16950 28 2002 32220 16250 2002 25813 15950 25 2002 28450 Model 1 TOYOTA Corolla 2.0 D4D HATCHB TERRA 2/3-Doors 2 TOYOTA Corolla 2.0 D4D HATCHB TERRA 2/3-Doors 3 TOYOTA Corolla 2.0 D4D HATCHB TERRA 2/3-Doors 4 TOYOTA Corolla 2.0 D4D HATCHB TERRA 2/3-Doors 5 TOYOTA Corolla 2.0 D4D HATCHB SOL 2/3-Doors 6 TOYOTA Corolla 2.0 D4D HATCHB SOL 2/3-Doors 7 TOYOTA Corolla 2.0 D4D 90 3DR TERRA 2/3-Doors 8 TOYOTA Corolla 2.0 D4D 90 3DR TERRA 2/3-Doors 9 TOYOTA Corolla 1800 T SPORT VVT I 2/3-Doors 10 TOYOTA Corolla 1.9 D HATCHB TERRA 2/3-Doors 11 TOYOTA Corolla 1.8 WTL-i T-Sport 3-Drs 2/3-Doors 12 TOYOTA Corolla 1.8 16V WTLI 3DRT SPORT BNS 2/3-Doors 13 TOYOTA Corolla 1.8 16V WTLI 3DR T SPORT 2/3-Doors 14 TOYOTA Corolla 1.8 16V VVTLI 3DR T SPORT 2/3-Doors 15 TOYOTA Corolla 1.8 16V VVTLI 3DR T SPORT 2/3-Doors 16 TOYOTA Corolla 1.8 16V WTLI 3DRT SPORT 2/3-Doors 17 TOYOTA Corolla 1.8 16V WTLI 3DR T SPORT 2/3-Doors 18 TOYOTA Corolla 1.6 VVTI Linea Terra Comfort 2/3-Doors 19 TOYOTA Corolla 1.6 16v L.SOL 2/3-Doors 20 TOYOTA Corolla 1.6 16V WTI 3DR TERRA 2/3-Doors 21 TOYOTA Corolla 1.6 16V WTI 3DR TERRA 2/3-Doors 22 TOYOTA Corolla 1.6 16V VVTI 3DR SOL AUT4 2/3-Doors 23 TOYOTA Corolla 1.6 16V VVTI 3DR SOL 2/3-Doors 24 TOYOTA Corolla 1.6 16V WTI 3DR SOL 2/3-Doors 25 TOYOTA Corolla 1.6 16V WTI 3DR SOL 2/3-Doors 26 TOYOTA Corolla 1.6 16V WTI 3DR SOL 2/3-Doors G H I J K L Fuel_Type HP Met_Color Color Automatic cc Diesel 90 1 Blue0 2000 Diesel 90 1 Silver 0 2000 Diesel 901 Blue 2000 Diesel 90 0 Black 2000 Diesel Black 2000 Diesel 90 0 White 2000 Diesel 90 Grey 2000 Diesel 90 1 Grey 2000 Petrol 1920 Red 1800 Diesel 69 0 Blue 1900 Petrol 192 Silver 1800 Petrol 192 Red 0 1800 Petrol 1920 Red 1800 Petrol 192 Black 1800 Petrol 192 Grey 1800 Petrol 192 Grey 1800 Petrol 1921 Grey 1800 Petrol 110 Blue 1600 Petrol 110 0 1600 Petrol 110 Grey 1600 Petrol 110 1 Blue 1600 Petrol 110 Grey 1600 Petrol 110 1 Black 1600 Petrol 110 1 Black 1600 Petrol 110 Grey 1600 Petrol 110 Blue 1600 14 0 بیب 15 بیب 32 بیب بیب بیب 19 بیب Grey بیب 21 بیب بیب 23 بیب 24 3 25 26 27 29 3 3
How would I make the Excel speadsheet do these things in seperate colums?

Answer 1

1. Use the formula =LOWER(text). This will convert description of "Model" in lowercase. Then do Paste Special for the matter converted into Lower text. Select the entire column, go to Data --> Text to Columns --> Delimited --> Next --> tick on Space --> Next --> Finish. This will ensure each of the matter is mentioned in separate columns.

2.    Use the below formula for the above data -

=CONCATENATE("Priced at $",C2,", Car id #",A2," is a ",M2,"-door,",L2,"cc,",LOWER(G2),",",LOWER(J2)," ","corolla")

3. Function to extract last 2 letters of Column E shall be - =RIGHT(E2,2)

4. Use the function =LEN(text) to count letters in a word

5. In order to show formulae, click on the tab Formulas-->Show Formulas

Click on Ctrl + P to Print. In the Settings --> select Landscape orientation. Under Page Setup, select Fit to : 1