Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Change character while copy
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 |
#3
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reminder notifications in a column | Excel Discussion (Misc queries) | |||
Excel won't copy outside sheet | Excel Discussion (Misc queries) | |||
Use DocProps in a change declaration | Excel Worksheet Functions | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
copy paste cell character limit | Excel Discussion (Misc queries) |