For example i have an email given like : jane [email protected], how would i remove the gap using a text function for it to be [email protected] ?
For example i have an email given like : jane [email protected], how would i remove the gap using a text function for it to be [email protected] ?
In A1 Cell
jane [email protected]
In B1 Cell
=SUBSTITUTE(A1," ","")
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
That gave me this =SUBSTITUTE([@[Email Address]]," ","") when i clicked enter, is it because i used a concatenate function to get the full name?
Don't click on A1, just manually type the cell address in.
Another way would be to highlightthat range, press CTRL H (find/replace), Find space (press the space bar), replace with nothing
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I just did that and it still gave me =SUBSTITUTE(e2," ",""), after i clicked enter again
so i highlight the range of all the spaced emails the click control H, the find/replace came up then in the find box i press the space button and in the replace i don't input any text then pressed enter, it told me it could not find what i'm looking for
Here you can take a look
In E, why not just use...
=Table1[[#This Row],[Firstname]]&Table1[[#This Row],[Lastname]]&"@excelstuff.ca"
The other suggestions wont work because you are working with a formula in that cell
Hi sorry what does #This Row mean? And first name and last name is it the direct names ?
It's still didn't work
I think the table has a setting that only when inputed gives the correct full email address
Because the question says The first type of email is in the format of “[email protected]”. Add a column called “E-Mail Address” and use a nested text function to turn the “Full Name” of an employee into the desired email.
I put this in F2 and it worked fine in all rows.
Formula:Please Login or Register to view this content.
Does this do what you want?
Thanks a bunch all of u!
You needed to format Column F by Highlighting --> Right Click---> Format Cells ----> An Select General. It will Work
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks