View Single Post
 
Old 05-26-2017, 07:13 AM
riothecat riothecat is offline Windows 10 Office 2007
Novice
 
Join Date: Nov 2016
Posts: 27
riothecat is on a distinguished road
Default

after you do text to columns, in a cell next to your 3 cells of numbers, put =a1&b1&c1 (or whatever your 3 cells are) then delete the 3 cells of numbers.

GEBOB taught me that one.
Reply With Quote