Get instant live expert help on I need help with blank text copy

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Change of plans, I would like to auto generate sheet1 to copy selected text from column A all the way down until there is a new text and then copy the new text all the way down until there is again another new text. so the formula should read something like = IF CELL A 1 IS NOT BLANK COPY IT UNTIL A IS NO LONGER BLANK WHEN THAT OCCURS COPY NEW TEXT UNTIL IT IS INTERRUPTED BY NEW TEXT???
Solved by F. B. in 16 mins
I have a series of formulas and if the formulas return text i want to copy it. if cells a1:a100 have text copy the text.
Solved by G. W. in 25 mins
remove text "blank" from all the rows in column G
Solved by I. Q. in 24 mins
if cell b2 has text then copy text from a1 to b1
Solved by F. F. in 17 mins
I need to copy text from one cell into another cell that already has text in it
Solved by K. D. in 24 mins