Formula for multiple cells

[ste1200]

Hi, I'm setting up a website and I need to manipulate my current inventory from 1 spreadsheet template in to another.

I need to be able to enter the following information in 1 cell (A1):

<p>OUT</p>
<p>OUT 3609</p>
<p>A1 Change Your Time (Club Version) 6:30</p>
<p>A2 Change Your Time (Acappella Version) 4:43</p>
<p>B1 Change Your Time (Instrumental Version) 5:55</p>
B2 Change Your Time (Edit Version) 4:26

Cell A2 contains the word OUT
Cell A3 contains the word OUT 3609
Cell A4 contains the words A1 Change Your Time (Club Version) 6:30

and so on.

Is it possible to do this and also to automatically add the html please ?

Thanks in advance.
Ste

[martindwilson]

you could probably parse out anything from that what do you mean by "add the html"?

[ste1200]

you could probably parse out anything from that what do you mean by "add the html"?

I mean add the <p> and </p> at the beginning and end of each line

[ste1200]

and what do you mean by parse out please ? I've googled it and I can see how to split information from cells eg John Smith in A1 to John in A2 and Smith in A2, but not the other way around,

[martindwilson]

if i copy paste that straight into excel it comes out as


a1 <p>OUT</p>
a2 <p>OUT 3609</p>
a3 <p>A1 Change Your Time (Club Version) 6:30</p>
a4 <p>A2 Change Your Time (Acappella Version) 4:43</p>
a5 <p>B1 Change Your Time (Instrumental Version) 5:55</p>
a6 B2 Change Your Time (Edit Version) 4:26
or do you mean your entering stuf in a2 a3.. and want it to appear in a1?

[ste1200]

I don't think you understand what I mean. I will try to explain it a bit easier. At the moment I have in a spreadsheet the following record label info and tracklisting, please don't be confused with the A1, A2 etc. they are not cells but track numbers.

B1 OUT
C1 OUT 3609
D1 A1 Change Your Time (Club Version) 6:30
E1 A2 Change Your Time (Acappella Version) 4:43
F1 B1 Change Your Time (Instrumental Version) 5:55
G1 B2 Change Your Time (Edit Version) 4:26

I need all this information in box A1 but with <p> at the beginning of each line and </p> at the end of each line, so it would look like this:

A1 <p>OUT</p>
<p>OUT 3609</p>
<p>A1 Change Your Time (Club Version) 6:30</p>
<p>A2 Change Your Time (Acappella Version) 4:43</p>
<p>B1 Change Your Time (Instrumental Version) 5:55</p>
B2 Change Your Time (Edit Version) 4:26

If it can't be done with the html then I could add that manually.

[martindwilson]

like this?
or even v2

[ste1200]

Perfect, many thanks for that