VBA copy and paste part of cell

Column A contains an ID number and a font: TF876 Brush Script. Each cell in Column B contains unique text: Unique text here

I would like to copy the font name from column A and add it to Column B, while also adding the word "Font".

The final result in column B should look like this: Font: Brush Script Unique text here

I am a beginner with VBA, can anyone push me in the right direction?

Thanks so much!

#excel-vba

2 Likes3.10 GEEK