Forum Discussion
Macro voor changing text content in cel
I have cells with lastnames and initials placed like: Houten A.D. van This must be changed into: A.D. van Houten I select the initials in the formula bar and press Ctrlx, Home, Ctrlv, Space, Tab,...
Hi Kristel,
Not sure about the macro, but why don't you try Flash Fill? https://support.office.com/en-us/article/using-flash-fill-in-excel-3f9bcf1e-db93-4890-94a0-1578341f73f7