Hi,

This is my first post and I glad to be here as I have been looking for a forum like this for sometime now.

Well anyway, here goes.

I have made a excel worksheet that automatically imports a file, sort the columns and deletes unnecessary columns that is not needed.

The only problem that I have when I import a txt file into excel is that it has a main category and a sub category column. Well I would like to convert them two columns to a single column where the information from the first column would be split from the second column using a " > ".

I know how to do this using a formula in Excel, but after I have merged the two columns together to make one, I then want to delete the other two columns. But when I do that, my merged columns information then disappears, which I don't want.

Is there anyway of changing the merged columns information so that the information contained within it changes from a formula to actual text just as if you typed it in your self.

I hope you can help!

Thanks!