copyboy007
Board Regular
- Joined
- May 17, 2005
- Messages
- 64
- Office Version
- 2016
- Platform
- Windows
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.
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.