Thread: How do I add 1 to a number in column b
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Luke M Luke M is offline
external usenet poster
  
Posts: 2,722
Default How do I add 1 to a number in column b
If you literally wrote "22 years" into a single cell, the manipulation needed
is:

=LEFT(B2,FIND(" ",B2)-1)+1&" years"
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"diana" wrote:

I have a spreadsheet in which column b refers to the number of years of safe
driving. ie "22 years". How do I add 1 to each cell in column B?
Reply With QuoteReply With Quote