long story short - because the table that has the full information is
needed for its own functions, but in another area of the speadsheet I
need a table that only has the server name.

On Apr 11, 5:29 pm, Gord Dibben <gorddibbATshawDOTca wrote:
How about EditReplace

What: \

With: nothing

Replace all.

If you want them both in same cell, enter =A1&" and " &A2 in an adjacent cell.

Gord Dibben MS Excel MVP