| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help on below
hi,
i need help to look value in the particular cell which contains both numbers and text or may be just numbers. if it contains numbers and text thn pick the number and multiply by 10 and if just number than display the current number in it. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help on below
Would be useful to post an example of length of text and if there's any patten. The easy bit is working out if it's a number =IF(ISNUMBER(A1)=TRUE,A1,"") VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=565813 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
