Thursday, 15 April 2010

if statement - Excel Column Equal to Text and Cell -



if statement - Excel Column Equal to Text and Cell -

i'm trying fill column url text , column info straight after slash in url column.

for illustration want input http://xxx.xxx.xxx/ column info goes here

the text url address , right after slash need column info go.

can help me out?

try concatenate function.

=concatenate("http://xxx.xxx.xxx/", a1)

excel if-statement excel-formula

No comments:

Post a Comment