• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Separating data entered using Alt+Enter in a cell

V

veronica.mam

New Member
Hi All,


I want to separate out data tht was entered using Alt+enter. I have used TTC but the problem is that it does not give the desired output. With TTC, the data gets separated into different columns. I do not want that. I want to separate the data into single column but in different rows.

Can anyone pls help me with this !


Thanks in advance

Veronica
 
Hi Veronica,


is the data in the cell formatted, that is does it always start at the same point in the cell. You can use the MID, LEFT, RIGHT functions to retrive the data from the cell.


Or you could FIND a character within the cell to act as a reference point.
 
Hi Veronica


Try the folowwing =FIND(CHAR(10),C4,1)

it should return the position of the ALT Enter in your text
 
Veronica,

You can either use kchiba's idea of using the FIND function, or stick with TTC but do a copy & paste special - transpose to switch things to rows. Do either of these ideas work for you?
 
You must log in or register to reply here.
Back
Top