Splitting Cell in multiple rows

[JonathanReard]

Hello,

I need to split up a cell with for example values "Active" and "Inactive" above each other, but which are in the same cell.
Could somebody give me a function or VBA code, which could do this split? Splitting a cell in multiple columns already exists.

This is urgent!
Thanks in advance!

[JonathanReard]

To give a better example:

Active (dormant)
Active

Above is one row(Cell), I need one row(Cell) with "Active (dormant)" and the next with "Active".
Thanks!

[Vikas_Gautam]

You can do one thing..
you can write Active and dormant manually in to cells..
and Merge (two adjacent cells) in each column horizontally..

Check the attachment ...

Say thanks, Click *

[Vikas_Gautam]

Did that help..?
Jonathan...

waiting for reply...

Say thanks, Click *

[Hawkeye16]

Vikas - That is the opposite of what he is trying to do, and merging cells overwrites all information except what is in the first cell of the range you are merging. Perhaps I misunderstood what you were saying?

As for your answer, I am not sure what character the in cell carriage return is but you could use the MID, LEFT, RIGHT functions along with a FIND function to determine where the carriage return happens.

edit: Quick search it may be Char(10).

So in one cell A2 =Left(A1,Find(Char(10),A1)) and in A3 = Right(A1,Len(A1)-Len(A2))

This worked for me

[JonathanReard]

Worked, thank you so much!!