Removing characters from a cell

		Microsoft Office Forums > Microsoft Excel > Excel
Removing characters from a cell

FAQ

Mark Forums Read

Thread Tools

Display Modes

01-11-2016, 02:35 AM

xor

Windows 10 Removing characters from a cell

Office 2013

Expert

Join Date: Oct 2015

Posts: 1,101

Extract 25: =LOOKUP(9^9,--LEFT(A1,ROW($1:$100)))

Extract ea: MID(A1,FIND(" ",A1,1),LEN(A1))

or: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBST ITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( SUBSTITUTE(A1,0,""),9,""),8,""),7,""),6,""),5,""), 4,""),3,""),2,""),1,"")

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Strange Characters appear when selecting SHOW ALL NON PRINTING CHARACTERS	ann Amber	Word	1	08-01-2015 08:06 PM
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to?	bharathkumarst	Excel	7	10-13-2014 10:25 AM
Word VBA: Cannot Edit Range (Delete characters except the first in a table cell)	tinfanide	Word VBA	3	04-27-2012 09:48 AM
Junk characters (box-like characters) in Word file	Sashikala	Word	1	04-20-2010 02:03 PM
Removing data between two characters	Voodoo Child	Excel	1	11-26-2009 01:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:15 AM.