I have a single column of different numbers in 33,000 rows. I need to add a prefix in front of each number for all 33,000 numbers. The prefix is BB/. I have tried the 'replace' command tool which does work but far too time consuming for all those different numbers. Is there a shortcut to achieve this ?
Bookmarks