Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grabbing text from just part of a cell
Hi all, I have sheets that come in that include a cell that says, for instance 'Subject no.: 5'. How would I grab just the '5' part of that cell? Help appreciated, thanks -- Mary ----------------------------------------------------------------------- Mary T's Profile: http://www.excelforum.com/member.php...fo&userid=3015 View this thread: http://www.excelforum.com/showthread.php?threadid=49834 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grabbing text from just part of a cell
The following function will grab whatever follows the colon space:
Function SubjectNum(InitialValue As String) As String Dim l As Long 'Find the location of the colon and add 1 for the space l = InStr(1, InitialValue, ":") + 1 SubjectNum = Right$(InitialValue, Len(InitialValue) - l) End Function -- Kevin Backmann "Mary T" wrote: Hi all, I have sheets that come in that include a cell that says, for instance, 'Subject no.: 5'. How would I grab just the '5' part of that cell? Help appreciated, thanks! -- Mary T ------------------------------------------------------------------------ Mary T's Profile: http://www.excelforum.com/member.php...o&userid=30151 View this thread: http://www.excelforum.com/showthread...hreadid=498349 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grabbing text from just part of a cell
That worked great, thanks! -- Mary T ------------------------------------------------------------------------ Mary T's Profile: http://www.excelforum.com/member.php...o&userid=30151 View this thread: http://www.excelforum.com/showthread...hreadid=498349 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF cell contains part of text | Excel Worksheet Functions | |||
copy selected part number of text from one cell into another cell | Excel Discussion (Misc queries) | |||
Get part of text in a Cell | Excel Discussion (Misc queries) | |||
find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) | |||
USE PART OF TEXT FROM ONE CELL IN ANOTHER | Excel Discussion (Misc queries) |