Previous Topic Next Topic

If cell has text then go to sheet x and insert

Closed
Finfool - Updated by Finfool on 7/02/17 at 12:35 PM
 Finfool - Feb 7, 2017 at 01:23 PM
Hello,

I need a formula that can insert text on another sheet.

So sheet 1 A1 has text then take that text insert it into Sheet 2 line "to be determined" and add this text with it.

1 response

Answer 1 / 1
Finfool
Feb 7, 2017 at 01:23 PM
=IF('Sheet1'!B16 <> "","Bob "&'Sheet1'!B16,"!")

Similar discussions

If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Copy data onto sheet only if cell has text
danipants -
checjb -

17 responses
Excel - IF function with multiple words
Nick -
user -

14 responses