insert text in front of other text data already in a column.

**jitterbug888** · 10-15-2016, 11:15 PM

Hi!

I have a column of url links that are incomplete, I want to insert

https://domainname.com/ in front of each url link in the column. (each cell in the column needs that put in front of it with no spaces.

the end result would be...

https://domainname.com/username-item-sku1
https://domainname.com/username-item-sku2
https://domainname.com/username-item-sku3
https://domainname.com/username-item-sku4

etc...

whats the best way to do this?

kind regards,

**JBeaucaire** · 10-15-2016, 11:18 PM

Assuming those link strings are in column A starting at A2, put this in B2 and copy down:

=HYPERLINK("https://domainname.com/"&A2, "Link")
or
=HYPERLINK("https://domainname.com/"&A2)

**jitterbug888** · 10-19-2016, 10:24 PM

Thankyou so much !!

insert text in front of other text data already in a column.

LinkBack

Thread Tools

Rate This Thread

Display

insert text in front of other text data already in a column.

Re: insert text in front of other text data already in a column.

Re: insert text in front of other text data already in a column.

Thread Information

Users Browsing this Thread

Similar Threads

more questions than answers, trying to remove the ' from in front of text in imported text

[SOLVED] adding text in front of potentially existing text (in 1 cell) with IF/THEN statement

[SOLVED] Need to trim various prefixed that are in ALL CAPS off of the front of text in a column

[SOLVED] Insert a space in front of all upper case text

insert text in front of Text OR number - user defined format

Printing DATA found in another column with text in front of it on a different column.

[SOLVED] HowTo add a period to front of EVERY text cell in a Excel column

Bookmarks

Bookmarks

Posting Permissions