EXCEL join two cell one with name to email

zonecrash

BANNED

Sep 30, 2009

72

70

• Oct 11, 2009

• #1

EXCEL join two cell one with name to email


B1 has the name

and

In C1 I want to complete the cell as an email l



Example;
B1 --- williamDavis

C1 --- join B1 to @yahoo.com - RESULTS of "C1" to be [email protected]


I have tried in C1

[email protected]
[email protected]


NO luck


Note;
I am using openoffice if that matters. Spreadsheet.

 

supermat007

Regular Member

May 8, 2008

260

410

• Oct 11, 2009

• #2

in C1 put

Code:

=B1&"@yahoo.com"

 

zonecrash

BANNED

Sep 30, 2009

72

70

• Oct 11, 2009

• #3

thanks

 

Last edited: Oct 12, 2009

zonecrash

BANNED

Sep 30, 2009

72

70

• Oct 11, 2009

• #4

it work ... now I am almost there... I have a few more issus
It may be foolish for you but i am settting up a imacro for regist-

My next step would be for posting

I hope I can pm you something?

 

S

Sarah Mathews

Senior Member

Jr. VIP

Sep 1, 2009

1,077

238

• Oct 11, 2009

• #5

Try this:

=concatenate(B1,"@yahoo.com")

This is an Excel function. Haven't tried it in OpenOffice Spreadsheet.

-SDT

 

0

0zero2hero

Newbie

Jun 18, 2009

15

1

• Oct 11, 2009

• #6

I don't know how to do that with openoffice, in excel you need to type:

=CONCATENATE(A1,B1)

hope it helps

 

zonecrash

BANNED

Sep 30, 2009

72

70

• Oct 12, 2009

• #7

thank you ... thanks you ...

With the help, I have resolved the issue

great suggestons

 

S

S M W

Junior Member

May 8, 2009

135

49

• Oct 12, 2009

• #8

or an alternate... copy the contents of the cells b1 and c1 (columns), then paste that into notepad ++. you will notice a space between the name and @domain.com. use find and replace to find your space and delete! the output is the same.

 

J0E

Senior Member

Jr. VIP

Nov 14, 2008

802

1,041

• Oct 12, 2009

• #9

S M W said:

or an alternate... copy the contents of the cells b1 and c1 (columns), then paste that into notepad ++. you will notice a space between the name and @domain.com. use find and replace to find your space and delete! the output is the same.

Click to expand...

I have been doing this for the past couple of months on a daily basis.... Thought that nobody else was doing it tht way until I read ur post..lol