Welcome Guest [Log In] [Register]
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:

Username:   Password:
Add Reply
Extracting Characters from Text Without Using Form
Topic Started: Mar 22 2007, 07:08 PM (127 Views)
Ahmaq
Member Avatar
Hum sa ho to saamnay a'ay
Admins
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.
Offline Profile Quote Post Goto Top
 
Ahmaq
Member Avatar
Hum sa ho to saamnay a'ay
Admins
Posted Image
Offline Profile Quote Post Goto Top
 
Iffi
Member Avatar
Ser Dada/Ser Dadi
[ *  *  *  *  *  *  *  * ]
nice
Offline Profile Quote Post Goto Top
 
1 user reading this topic (1 Guest and 0 Anonymous)
« Previous Topic · Roshnee · Next Topic »
Add Reply