0

How To Add Prefix In Excel

EmekaFeb 21, 2011 | edited Feb 21, 2011 - by @Emeka

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.

Emeka@Emeka+ Follow
0
Emeka+ Follow
joinedJul 31, 2021

More from @Emeka