How To Add Suffix In Excel

by

In order to suffix in excel, you are going to need this formula below;

=Cellnumber&”Suffix”

You will need to choose another cell, for example if your data are in cell A, and your suffix is http:// , you will want to type this below in another cell;

=A1&”http://”

Having done that, press enter. If you have more data in cell A’s column, after pressing enter, you have to move your cursor to the entered formula and hold it while dragging it down all the way to the last row where your data column terminates.

  

   

Recommendations For You: