Question about Computers & Internet

I have a question; How do I seperate address written in one column into 4 column as line1 line 2 citi pincode

Posted by on

×

• Level 1:

An expert who has achieved level 1.

Mayor:

An expert whose answer got voted for 2 times.

Problem Solver:

An expert who has answered 5 questions.

• Contributor

Assuming 1) you're using Excel and 2) the addresses are written:

1234 Main St., Anytown, CA 90210

You can use "Text to Columns" feature (selected "Delimited" and check the box next to "comma"). This will split the data into 3 columns (address | city | state and zip). Then run the "Text to Columns" again on the "state and zip" column and use "Fixed width" to separate the state from the zip.

If the assumptions I used are incorrect, clarify and we'll try again.

Posted on Jan 06, 2009

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

Complete. Click "Add" to insert your video.

×

Related Questions:

Round 3 to ten

Rounding 3 to the nearest tens.

The process should always be the same.

Step 1 - identify the column in question.
Step 2 - go the the column immediately to the right of this column
Step 3 - if this number is 5 or more, add 1 to the column in question and make all numbers to the right 0, or if to the right of the decimal, eliminate them.
Step 4 - if this number is 4 or less, don't add 1 to the column in question and make all number to the right 0, or if to the right of the decimal, eliminate them.

To assist, I have written the number as 03.

Step 1 - Tens column is the 0.
Step 2 - Column immediately to the right is 3
Step 3 - Number is not 5 or more
Step 4 - Number is 4 or less, set the numbers to the right to 0

The answer is 0. The numbers -4, -3, -2, -1, 0, 1, 2, 3, and 4 when rounded to the nearest 10, all round to 0.

Good luck,

Paul

Oct 11, 2016 | Office Equipment & Supplies

Kenwood service center kerala

Hi, Hope this helps.

Kenwood Service Centre Cochin Address Address :
Pukalakattil Building,
Palarivattom
City : Cochin
Kerala, India.
Pincode : 0.

Kenwood Cochin Service Centre Contact Details :

Phone Number : 9349519613
Website : http://www.kenwood.com/india/

Dec 13, 2014 | Kenwood Food Processors

To show me how to break the number 127 to binary form

Let's start by setting up the binary columns.
2^0 = 1
2^1 = 2
2^2 = 4
2^3 = 8
2^4 = 16
2^5 = 32
2^6 = 64
2^7 = 128

Written horizontally.

128 64 32 16 8 4 2 1
1 1 1 1 1 1 1
What is the biggest number that goes into 127. 64. Put 1 in the 64s column. 127 - 64 = 63.
What is the biggest number that goes into 63. 32. Put 1 in the 32s column. 63 - 32 = 31.
What is the biggest number that goes into 31. 16. Put 1 in the 16s column. 32 - 16 = 15.
What is the biggest number that goes into 15. 8. Put 1 in the 8s column. 15 - 8 = 7.
What is the biggest number that goes into 7. 4. Put 1 in the 4s column. 7 - 4 = 3.
What is the biggest number that goes into 3. 2. Put 1 in the 2s column. 3 - 2 = 1.
Put a 1 in the 1s column.

So we have 1111111 in binary.

Good luck.

Paul

Oct 02, 2014 | Office Equipment & Supplies

What is thecontact details of thoshiba service centre in thrissur?

Toshiba Laptop Service Centre Thrissur Address Address :
Tc-35/618, Shanti Nagar, Thiruvanmbady
City : Thrissur
Kerala, India.
Pincode : 0.

Toshiba Laptop Thrissur Service Centre Contact Details :

Phone Number : 9744655443 Website : http://www.toshiba-india.com/laptop/

Aug 22, 2014 | Toshiba Computers & Internet

Transcend 16gb pendrive note formating error & it is wright protected

u can format ur pendrive, boot ur system on safe mode

step -1 restart ur system and press F8 then u will get some options choose safe mode without or with networking, when u successfully logged in safe mode insert ur memory card or pendrive in system u will able to format it. if problem still
here are transcend service center details in bangalore

Transcend Service Centre Bangalore Address Address :
No:2 & 3, New Raja Building, 2nd Floor, Nr Road
City : Bangalore
Karnataka, India.
Pincode : 560002.
Phone Number : 41129213, 41129213, 9740975091
Email-id : vigu@amatrainfotech.com
Contact Person : Vigneshwari
Website : http://in.transcend-info.com/

Mar 16, 2014 | Transcend Electronics - Others

I have an older T-103 and it ran great for years until I unhooked it and stored it. I want to use it again and in looking online at the new T-103's, I noticed that mine does not have a lug marked A ! I...

I can tell you this. Line 1 and Line 2 are for the two electrical supply wires. If it is a 120 volt unit, these may be black (hot) and white (neutral). The two small white wires are connected to these two terminals and go back and connect this 120 volt supply to run the clock.
Then your "load" is whatever you are operating, like a pool pump. The two wires to that are connected on Load 1 and Load 2.
Your header says 120 volt timer, so it probably will self destruct on 240 volts.
Gary

Dec 28, 2010 | Intermatic T103 Indoor 120-Volt 40-amp...

I forgot my pincode of my phone..? how 2 unlock the pincode? my phone is nokia3120classic

find the little plastic card size of a credit card when your sim card was. there is written your pin, puk, and your num

Jun 24, 2010 | Nokia Lands Phones

On dailing any number, it is showing call failed while incoming call are coming. On the screen it is showing line 2. Please help in solving the problem

Depending on the model no of your phone, your phone has the option to choose between "Line1" and "Line2" from network settings. You can either choose "Line1" from the settings or restore your phone to factory defaults,

Oct 12, 2009 | Lands Phones

2 Telephone lines and one phone jack

Most of the Cordless 2 line phone BASE UNITS have the connections on the back for line1/line2 or seperate line 1 and line 2 connection. If you have the type of phone with the line1/line2 jack you have to be sure that both lines are on the same wall jack, otherwise make sure the phone you purchase has seperate line jacks and you will have two phone cords going to the base unit.

Jul 26, 2008 | Lands Phones

Cant recieve calls

make sure your pincode is not blocked and outgoing line is selected to line1 and the connection has outgoing call facility from yur operator

Apr 24, 2007 | Motorola Mobility RAZR V3

Related Topics:

67 people viewed this question

Usually answered in minutes!

Level 3 Expert

Level 3 Expert