Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-24-2012, 12:54 AM
gsrikanth gsrikanth is offline star has to come Windows XP star has to come Office XP
Competent Performer
star has to come
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default star has to come







i want formula to * in b1 related with spaces in c1
i inserted column between two rows ie., c1 become d1

i keep formula
=if(and(b1="*",len(d1)>1,"*","")

my question is how to make "*" stable until the length d1 is one
find the attachment
Attached Files
File Type: xlsx Book1.xlsx (11.0 KB, 6 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
star has to come Editing star autoshape ttrof Drawing and Graphics 2 05-06-2011 02:11 PM
How to create a moving Star higlight Quest PowerPoint 0 02-09-2010 03:43 PM
star has to come Star DP8340 Printer Alarm light on jim2034c Office 2 11-05-2005 10:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:19 AM.


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