How To Add Prefix In Excel

by

To add prefix in excel, you need this formula below;

=”prefix”&Cellnumber

First you need to pick another cell, for instance if your data are in cell A, and your prefix is www. , you should type this below in another cell;

=”www.”&A1

After that, hit enter. If you have more data down cell A’s column, after hitting enter, you should move your cursor to the entered formula and drag it down all the way to the last row where your data column ends.

  

   

Recommendations For You: