Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Stripping section of text
I'm looking to strip off all characters to the left of a certain
target character and encase the results in single quotes. The problem is that the characters to the left or right of the target character vary in quantity. Email addresses for example in cell A1: would then become ' This may require nested function but I can't get the one I though tof to produce all of the characters to the right of the @ character. =RIGHT(A1,FIND("@",A1,1)) but the results are il.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
How do I compare two columns on seperate sheets and replace text . | Excel Worksheet Functions | |||
how to hyperlink text to a cell | New Users to Excel | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
Stripping mixed number and text | Excel Worksheet Functions |