Dear Anyone,
I have excel data where it runs like below
Lumina
006
Ali Rashid Al Amin
61.40
Date
03/04/2013
11/04/2013
14/04/2013
check
20
Raja
I need a result colum containing as below but where the numbers are removed those cells has be
Lumina
Ali Rashid Al Amin
Date
check
Raja
Thanks in advance.....
Perhaps
=if(isnumber(a1),"",a1)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
You might be safer with this, in case some of your numbers, such as "006", are text.
Formula:
Please Login or Register to view this content.
If you also want to remove the blank rows try this CSE array
Confirm with Ctrl+Shift+Enter not just Enter before dragging down.
Formula:Please Login or Register to view this content.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Thanks indeed. Anyhow it doesn't remove the numbers in text format.Originally Posted by Fotis1991
thank you indeed all
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks