Excel Database

[adamibbo]

Guys I wonder if any you guys had an answer to a problem we've been having.

We have been sent a database of our customers and their requirements who have been onto our website in a .csv file. In one of the cells per line, all the data we need is on several lines and includes many spaces and lines between.

What we need to be able to do is for example get the customer name and email address out of the cell data and paste it into another without having to do it manually as there are over 7000 lines in the csv file.

Does anybody have any ideas?

Cheers

Adam

 

[adamibbo]

Select Column with data in, then go to the menu bar at the top and click:

Data - Text to columns

edit - then select 'Delimited' and chose the 'delimiters' that you wish to be split up. Eg if you tick 'space' then every 'space' character will result in a new column being used.

Hi

Cheers for the quick reply but I can only get this to work for the top line.It splits up "Below is the information supplied by a visitor completing the contact us request form" fine in the columns but stops after that.

The information below is an example of how it looks inside an excel cell.

Below is the information supplied by a visitor completing the contact us request form

on the **** website. It was submitted by L****** H******* (**@**********.co.uk)

on Friday, June 8, 2007 at 06:23:15

---------------------------------------------------------------------------



Name: L***** H*******



Email: **@***********.co.uk



Phone number: *** **** ****



Address: 28 ******* ****

******

******

*** ***


---------------------------------------------------------------------------

 

[adamibbo]

Is there definitely data in column A?

Try selecting more the columns before performing the delimiting.

I.e. highlight columns A - K or something then do it again.

Yeh theres definately data as shown above ^^ and it won't let me select more than one column as this error occurs.

Microsoft excel can only convert one column at a time. The range can be many rows tall but no more than one column wide.......

 

[adamibbo]

Could you post a screenshot of the first couple of rows of the spreadsheet?

Feel free to blank out any details, but it would help to see exactly how the data is laid out in Excel.

Hi mate

Image as asked basically the whole of the B column is full of these, just want to get the Name and Email addy into other cells. Cheers for the help all