Hello again. I'm fine tuning my line of questioning over the last few posts I've made...think I have it narrowed down to what I'm trying to do. I'm looking to take a string of text, split it across multiple columns, and insert additional text at certain points. Example of string:
FLG 1-1/2" 300 316 RF BLD
The separation would go as follows with the added text in parentheses:
FLG 1-1/2" 300(#) 316(SS) RF BLD
The idea would be to do this via macro. Anyone know of a way to go about this? It would be greatly appreciated. Apologies for the lack of workbook...I only have a phone at the moment.