I know how to merge data in a CSV (see attachment) from 2 columns into a single cell using =A1&" | "&B2 so that A1 (Safety Products) plus B1 (Fire Protection) becomes Safety Products | Fire Protection in cell C1, but how can I do this across multiple rows so that each pair of names is combined in each row?
The job I'm working with is a product CSV file that has 6370 lines so I don't want to do them one line at a time!
Malcolm
Last edited by ArtisanInternet; 12-08-2008 at 11:14 AM.
ArtisanInternet,
In your workbook, you could just copy the formula in cell C1 down to the end of your data. Then click on column C, click on Edit, Copy, Edit, PasteSpecial, Values.
If you are looking for a macro solution, then please post a workbook with the CSV data.
Have a great day,
Stan
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
That did the job, many thanks, you're a star
Malcolm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks