Auto suffix adding

[chssundeep]

Hi friends

I am entering emails data in excel file...Is there a way to add suffix to the text I entered automatically???

All my mail data have the suffix @gmail.comand i

Now I am using Column A to enter data

Whenever I finish entering data and press move to next row suffix i.e @gmail.com should be automatically added.

Example

in cell A1 i entered chandoo and moved to another cell then A1 should become chandoo@gmail.com

 

[Hui]

You could either use a custom number format like
;;;@".gmail.com"

Or use a second column
=A2&".gmail.com"

 

[chssundeep]

@Hui

Thanks for the help

It is working great the way I need

But one more request I am using ;;;@".gmail.com" it is returning as chandoo.gmail.com @ is missing

 

[Abhijeet R. Joshi]

Small amendment:

;;;@"@gmail.com"

 

[chssundeep]

thanks Abhi

it working great

Please explain me why should we use @ after ;;;

 

[Abhijeet R. Joshi]

this should be helpful..
http://chandoo.org/forum/threads/cell-format-negative-numbers.12766/#post-74991

 

[Hui]

The @ is a place marker for the Custom Format interpreter to place the text of the cell in that position
then it sees the "@.gmail.com" as plain text and appends that to the cells display

You can use other Custom Text Cell Formats like

Eg:
A Cell Contains: Chandoo
Use Cell Custom Number Format of @"."@"."@"."@
The Cell will display Chandoo.Chandoo.Chandoo.Chandoo

You get the idea