Hi,

I have few lines of text in a cell and I am not able to separate it with the
individual cell for each lines.
For ex: for one invoice number in cell B1, the text is some kind of merged,
if I click on that cell I can see entire data and I am not able to separate
it out.
I need invoice number and also the text of ( n number of lines) as in the
cell.

if a cell has 10 lines of text in a cell, the invoice number also should
repeat in 10 cells and also the 10 lines opposite to that.

Help me with any formula to work it out.

Thanks
Igneshwara reddy.

An example of what the text looks like would help

"Igneshwara reddy" wrote:

Hi,

I have few lines of text in a cell and I am not able to separate it with the
individual cell for each lines.
For ex: for one invoice number in cell B1, the text is some kind of merged,
if I click on that cell I can see entire data and I am not able to separate
it out.
I need invoice number and also the text of ( n number of lines) as in the
cell.

if a cell has 10 lines of text in a cell, the invoice number also should
repeat in 10 cells and also the 10 lines opposite to that.

Help me with any formula to work it out.

Thanks
Igneshwara reddy.

Hi,

The example is In cell A1 I have invoice number as 12345 and in Cell B2 as
follows :
"04/07/2008 01:14:54 PM<--FIELDSEP--JP185006<--FIELDSEP--PLEASE CANCEL THE
HELPDESK SUPPORT OF SITE 2201383, CONTRACT 1079097, EFFECTIVE 01-OCT-07,
REASON: UPGRADE TO PAR, REF: INVOICE 4718929

WHEN DONE, CREATE A MONTHLY CONTRACT FROM 01-OCT-07 TO 30-SEP-08 AND PRORATE
CUSTOMER FROM 01-OCT-07 AS PER ATTACHED

PUT THE SUB-LINE INVOICE TEXT AS INDICATED IN THE SPREADSHEET

BE SURE THAT ALL ATTACHED SERIAL NUMBERS HAVE THE PRODUCT REFERENCE SET TO
FM-PLATINUM A

PUT THE SEVERITY CODE AS INDICATED IN THE SPREADSHEET

PUT ""YEAR 1-FM"" IN THE P.O. FIELD

INVOICE FORMAT AS USUAL

SEND INVOICE TO CUSTOMER A.S.A.P.

ATTENTION: THIS CONTRACT WILL NOT BE RENEWED AT THE END DATE

THANKS<--RECORDSEP--"

Regards,
Igneshwara reddy

"akphidelt" wrote:

An example of what the text looks like would help

"Igneshwara reddy" wrote:

Hi,

I have few lines of text in a cell and I am not able to separate it with the
individual cell for each lines.
For ex: for one invoice number in cell B1, the text is some kind of merged,
if I click on that cell I can see entire data and I am not able to separate
it out.
I need invoice number and also the text of ( n number of lines) as in the
cell.

if a cell has 10 lines of text in a cell, the invoice number also should
repeat in 10 cells and also the 10 lines opposite to that.

Help me with any formula to work it out.

Thanks
Igneshwara reddy.