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.

Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as named ranges.
Count names in excel - Guide
Monk names wow - Guide
Where is the insert key - Guide
How to insert at the rate in laptop - Guide
My contacts list names - Guide

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

How can I make a WhatsApp profile name

Can no longer paste text into insta

help me to add particular cells

Can you rename the inputs on LG Smart TV (WebOS)?

Similar discussions

Subscribe To Our Newsletter!