Thread: [Solved] Removing characters from a cell
View Single Post
 
Old 01-11-2016, 06:34 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
=value(left(A1,find(" ",A1)-1))

=right(A1,len(A1)-find(" ",A1))
Reply With Quote