Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Copy data if the Cell A1 has 4 characters in total Copy data if the Cell A1 has 4 characters in total
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 05-31-2018, 04:23 PM
LearnerExcel LearnerExcel is offline Copy data if the Cell A1 has 4 characters in total Windows 7 32bit Copy data if the Cell A1 has 4 characters in total Office 2013
Advanced Beginner
Copy data if the Cell A1 has 4 characters in total 		 
Join Date: Nov 2016
Posts: 82
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default Copy data if the Cell A1 has 4 characters in total
How can I copy data of cell A1 to cell B1 if A1 has 4 characters in total else it should paste nothing?
Reply With Quote
  #2  
Old 05-31-2018, 05:33 PM
LearnerExcel LearnerExcel is offline Copy data if the Cell A1 has 4 characters in total Windows 7 32bit Copy data if the Cell A1 has 4 characters in total Office 2013
Advanced Beginner
Copy data if the Cell A1 has 4 characters in total 		 
Join Date: Nov 2016
Posts: 82
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default
I tried the following code which is working fine.

=IF(LEN(A1)<=4,A1,"")
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
If Cell Blank Copy Data from Above Combine All to Current ChrisOK Excel Programming 2 12-18-2017 11:25 PM
Copy data if the Cell A1 has 4 characters in total Need a formula to copy cell data with its format wfhin2016 Excel 12 04-23-2016 08:13 AM
Copy data if the Cell A1 has 4 characters in total copy row into new sheet dependant on cell data scorpain Excel 1 03-08-2016 02:37 PM
Copy data if the Cell A1 has 4 characters in total copy a cell from 1 file to another when data changes jpreeshl Excel 5 01-20-2016 09:06 AM
Copy all comments & cell contents (i.e. data) to word? IanM Excel 0 07-03-2010 11:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:46 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft