Removing characters from a cell

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

01-11-2016, 06:34 AM

gebobs

Windows 7 64bit Removing characters from a cell

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

=value(left(A1,find(" ",A1)-1))

=right(A1,len(A1)-find(" ",A1))

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 10:05 AM.