Merge data from differrent cells and arrange resulting text

[RAlmodovar]

I'm able to merge data from two cells into a third cell using concatenate.
I need help arranging the resulting text.
i.e.
Cell A1: xxx 1234
Cell B1: ddd

Combine to show on cell C1:
line 1: 1234
line 2: ddd xxx

 

[Rick Rothstein]

Your question is somewhat vague...

1) Is the number always 4 digits long?

2) Are the two text strings always 3 characters long?

3) If not always 3 characters long, can the text have spaces within it?

 

[RAlmodovar]

1) Is the number always 4 digits long? no, the number is 3 digits and my have one, two or three decimal places
2) Are the two text strings always 3 characters long? yes

Cell A1 is always 3 letters "space" and a 3-digit number with one, two or three decimal places
Cell B1 is always 3 letters

 

[Rick Rothstein]

Okay, then give this formula a try...

=MID(A1,4,9)&CHAR(10)&B1&" "&LEFT(A1,3)

Edit Note: Don't forget to turn on Wrap Text for the cell you put the formula in.

 

[RAlmodovar]

Thank You....it worked!!!