Thread: how to select the first character in a cell and delete the rest
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default how to select the first character in a cell and delete the rest
Hi,

Try this

=LEFT(A1,SEARCH("x",A1)-1)+0

Mike

"Helenf" wrote:

Hi and thank you in advance
I have a large spreadsheet where they have populated values like 3x3ml,
5x0.5ml etc. They are all pretty different. We only need the first numbers
before the x. How do I do this? Please help
Reply With QuoteReply With Quote