Adding a prefix to cell entries?

[sten28]

Hi guys,

I was wondering if Excel is able to check a cell to see if "

http://www."

is included at the start of the cell and insert "

http://www."

into the cell after data has been entered if it hasn't yet been entered?

Thanks!

Sten

 

[Fenrirshowl]

You could use =IF(LEFT(A1,4)<>"

http://www.","www."

& A1,A1)

If you need it to be a hyperlink simply include the HYPERLINK function.

Fen

 

[xlhelp]

It could be as simple as Fenrirshowl has indicated.

You could use =IF(LEFT(A1,4)<>"

http://www.","www."

& A1,A1)

or it could be a little complicated depending on whether there is http://

=IF(ISERROR(FIND("

http://www.",C1,1)),

IF(ISERROR(FIND("//",C1,1)), "

http://www."&C1,LEFT(C1,FIND("//",C1,1)+1)&"www."&RIGHT(C1,LEN(C1)-FIND("//",C1,1)-1)),C1)

Member- AAAA Association Against Acronym Abusers