Thread: remove blanks using formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gotroots Gotroots is offline
external usenet poster
  
Posts: 114
Default remove blanks using formula
I want to remove the blanks in "A" using a formula in "B"

example:

A1 - sand
A2 -
A3 - silt

Formula in "B"

B1 - sand
B2 - silt

Thankyou

Reply With QuoteReply With Quote