Yeah, I might be able to use that. Thanks.
After testing it, I'll convert it into a macro.

Thanks again!


"Dave O" wrote in message
ups.com...
Hi, John-
Suppose your existing data is in a tab called Sheet1; cell A1 contains
the text string ABCDE; cell B1 contains a number 12345.

Insert a new tab in the workbook- for purposes of this example I used
the default name Sheet2. In cell Sheet2!A1 enter this formula:
=MID(Sheet1!A1,1,3)&" "&MID(Sheet1!B1,1,3)
The result in Sheet2!A1 is "ABC 123".

The MID function returns a portion of a string function that you
indicate: in this example, it starts in Sheet1!A1 in column 1 and
returns the first 3 columns. The ampersand in the middle is a
concatenator that joins the results of different functions.
Can you modify this example to fit your application?