string concatenation

I have two columns that consist of strings that I want to combine in a certain way. The first column has a string that consist of numbers and letters and the second column just has 3 letter codes. What I want to do is get rid of the letters in the numbers string and then add the 3 letter code on to the end of the numbers, and have this placed in a seperate column.

For example: if column 1 contains "12F51Q" and column 2 contains "ABC" then the result would be "1251 ABC". Is this possible??

U can use this user define function.

Please Login or Register  to view this content.

If the alphanumeric cell will ALWAYS be 6 characters...then

With
A1 containing a 6-character alphanumeric string....eg 12F51Q
B1 containaing a text string................eg ABC

This formula prepends the numbers from A1 to the text of B1

Please Login or Register  to view this content.

In the above example, the formula returns: 1251 ABC

Is that something you can work with?
Post back if you have more questions.