Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #2   Report Post  
PeterAtherton
 
Posts: n/a
Default



"mnr" wrote:


Hi!
Given are the following columns e.g.: Surname and Name.
In a third column I would like to paste the contents of these cells
together to create an email addresses.

Example:
Column1: john
Column2: vön humboldt
Column3(=result):

The problems that arise and aren't solved yet:
PROBLEM1:
the spaces should be removed
PROBLEM2:
Special characters should be replaced. Writing a formula containing a
sub-formula for every character that should be replaced is quite
inefficient, resulting in a large formula. So is there an alternative?
A standard formula, trick,...?
to give you an idea:
ü (should be replaced by) u
éêëè e
âäÃ*Ã¥ a
ç c
etc...

lookings forward for solutions. thanks in advance!

Renee


--
mnr
------------------------------------------------------------------------
mnr's Profile:
http://www.excelforum.com/member.php...o&userid=24227
View this thread: http://www.excelforum.com/showthread...hreadid=378423

Renee

Assuming the name is on row 5 columns A and B then
=LOWER(A5&SUBSTITUTE(B5," ",""))&"@"

Use Edit, Replace to change é to e and repeat for each character

regards
Peter
  #3   Report Post  
olasa
 
Posts: n/a
Default


I don't like this solution, but it might solve your problem:
See enclosed:
http://www.excelforum.com/attachment...tid=3482&stc=1

Ola


+-------------------------------------------------------------------+
|Filename: Book4.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3482 |
+-------------------------------------------------------------------+

--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=378423

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
reminder notifications in a column L Mieth Excel Discussion (Misc queries) 6 June 10th 05 11:00 AM
Excel won't copy outside sheet Jack Sons Excel Discussion (Misc queries) 6 May 17th 05 10:05 PM
Use DocProps in a change declaration chris w Excel Worksheet Functions 7 January 22nd 05 12:35 AM
automatic color change in cells using a drop down list kennethwt Excel Worksheet Functions 1 January 21st 05 07:37 PM
copy paste cell character limit Fred Excel Discussion (Misc queries) 1 December 2nd 04 09:58 PM


All times are GMT +1. The time now is 12:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"