Extracting Alpha-Numeric Data for Concatenate

[copyboy007]

I have pairs of rows with numeric and alpha-numeric entries I'm trying to combine using concatenate. But, the first row includes extra numbers that are not needed.

4 AB1234
6

55 67890
94

345 45678
9x

Desired result:
AB12346
6789094
456789x

Is there a formula that can extract the numeric / alpha-numeric portion after the space?

At first, I tried: =CONCATENATE(RIGHT($a35,LEN($a35)-2),$a36)

but, it was capturing part of the extra numbers that went two digits and beyond.

 

[alansidman]

It would be helpful if you loaded your sample with XL2BB and posted it so that we can see and understand what you have

 

[Tetra201]

Maybe

=MID($A35,FIND(" ",$A35)+1,99)&$A36

 

[copyboy007]

Maybe

=MID($A35,FIND(" ",$A35)+1,99)&$A36

Works beautifully! Thank you so much!

 

[Tetra201]

You are welcome.