help with entering data in Excel, PLEASE!!!!?

Question

I have couple of hundred names and addresses, fax, phone numbers, positions etc. that i have to enter Excel.
For example in excel sheet it should appear as follow:
telephone number /company name/company address /city and state / zip code / contact name / contact position / fax number /
and the the text i have to enter is as follow:
Fake company
17605 Marry Jane Drive
Hollywood CA 95330
Marry Jane Vice President
[phone] (555)5555-2540

how can i make it easy instead of copy pasting the info in each field, is there any way i can have excel do this it’s self?
i know it’s hard to understand what i mean, it’s the best i can do to explain!
THANK YOU!

Answer 1

The easiest way of doing this is to copy the addresses into Word. Turn on the viewing of formatting marks so that you can see what is at the end of each line.



Use Search and Replace. Do a search for the character at the end of each line (except the character at the end of the last line of each record). and replace the end of line character with a comma.



Now copy the data into Excel and use the Text to Columns feature using the comma delimiter to separate the data into columns.



Done correctly, you can convert a few thousand addresses in a couple of minutes.

Answer 2

Hi,



First, for this type of database, you really should be using Access instead of Excel.



But, you can do this in Excel, and without using a macro (VBA) it does involve text to columns, copying, but instead of just paste, you would use "paste special" and check the Transpose box.



You'll need to get the zip and the 2nd phone # moved, so click the cell with city, st and zip, then click Text to Columns on the Data tab. Select Fixed width, click next, then get rid of the break line between city and state, and click finish.



Do the same with the phone # cell.



insert a row so you can drag the zip code down under the city/state, and drag the 2nd phone # down below the 1st one.



now select each cell (A1 to A7) and cut or copy, right click on B1 and select Paste special. Check the box at the bottom to Transpose the text, click OK



Everything is now in row 1. Just change your column widths to see everything.



Now, after doing that a few times, you'll probably decide to use Access after all.

Answer 3

that's an fairly vast difficulty which won't have the capacity to be written here. perfect is to purchase e book on excel and learn or connect some institute for effortless course im be conscious, excel, potential factor and so on.