| Assalamoalaikum, We hope you will enjoy your visit here. Join our community! If you're already a member please log in to your account to access all of our features: |
| Extracting Characters from Text Without Using Form | |
|---|---|
| Tweet Topic Started: Mar 22 2007, 07:08 PM (127 Views) | |
| Ahmaq | Mar 22 2007, 07:08 PM Post #1 |
![]()
Hum sa ho to saamnay a'ay
![]()
|
To extract characters from text: 1. Select column A. 2. From the Data menu, select Text to Columns. 3. In Step 1 of 3, select Fixed width, and then click Next. 4. In Step 2 of 3, parse the data in the column by clicking the mouse between columns as needed for parsing, and then click Next. 5. In Step 3 of 3, in the Destination box, enter cell B1, and then click Finish. |
![]() |
|
| Ahmaq | Mar 22 2007, 07:09 PM Post #2 |
![]()
Hum sa ho to saamnay a'ay
![]()
|
Posted Image |
![]() |
|
| Iffi | Apr 6 2007, 08:50 PM Post #3 |
![]()
Ser Dada/Ser Dadi
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]()
|
nice |
![]() |
|
| 1 user reading this topic (1 Guest and 0 Anonymous) | |
| « Previous Topic · Roshnee · Next Topic » |











![]](http://z5.ifrm.com/static/1/pip_r.png)
5:33 AM Jul 11