View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SJS SJS is offline
external usenet poster
 
Posts: 20
Default Remove data in a cell

I have a column of data where some of the data ends in ' 1' (space 1). How
do I remove the (space 1)?

For example:
test
trial 1

I need:
test
trial

tks,
steve