First, it's good to respond in the same thread.

Second, since you had multiple responses, you'll want to share the formula you
used--and what happened when you tried it.

Dave Peterson wrote:

Check the other suggestions at your original post.

PaolaAndrea wrote:

Hello,

Thank you for your previous reply, it was great.

One more variable than I didn't think about, if cell B2 is empty how can I
make sure that only A2 is populated and that I don't have a blank line on the
bottom?

Example:

A2 = 109 Vine Hill & B2 = (Empty)

Result:
109 Vine Hill

NOT:
109 Vine Hill
(Empty Line)

Thank you.

Sincerely,

PaolaAndrea

--

Dave Peterson

--

Dave Peterson