If you have downloaded your CSV/Excel file from Popular Chips and wish to convert the IG usernames/handles into clickable link, please follow this simple steps:
Download the CSV file from Popular Chips.
Open the file.
Depending on your Excel version and your language settings, the content in your excel file might appear like this:
If you don’t know how to convert text to column, please, follow this: How to Convert Text to Columns in Excel
Insert a column after the Username/Handle column, and name it: IG Link.
Copy& Paste this formula into the cell next to the first username/handle of the list: =CONCATENATE("https://www.instagram.com/",A2)
- Make sure that A2 is referring to the cell containing the first username/handle of the column. If your usernames/handles are in another column, change A2 with that column name ( B2 or C2 etc.).
- Make sure that A2 is activated. If it is, it will be coloured, and the related cell will be highlighted.
Then drag and copy this formula to the cells you want to transform. Et voilà: