Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Extracting from a text string
Hello everyone :) Hope someone can help with this question.... I have a field containing a text string, for exampe: "1 : 1.3". I want to be able to extract the 1.3 and show it in a separate column using a function. Is this possible ? The characters before the " : " can be any string length, but following the ":" the number I want to extract is always 2 places behind the " : ". Does this make sense ? Hope it does, and thanks for your help ! Amy xx :) -- AmyTaylor ------------------------------------------------------------------------ AmyTaylor's Profile: http://www.excelforum.com/member.php...o&userid=20970 View this thread: http://www.excelforum.com/showthread...hreadid=381708 |
#2
|
|||
|
|||
AmyTaylor Wrote: Hello everyone :) Hope someone can help with this question.... I have a field containing a text string, for exampe: "1 : 1.3". I want to be able to extract the 1.3 and show it in a separate column using a function. Is this possible ? The characters before the " : " can be any string length, but following the ":" the number I want to extract is always 2 places behind the " : ". Does this make sense ? Hope it does, and thanks for your help ! Amy xx :) Assuming your text is entered in Cell A1, your formula is =MID(A1,FIND(\":\",A1)+1,255) Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=381708 |
#3
|
|||
|
|||
Hey, thanks for your reply, many thanks - it works perfectly. Amy xx -- AmyTaylor ------------------------------------------------------------------------ AmyTaylor's Profile: http://www.excelforum.com/member.php...o&userid=20970 View this thread: http://www.excelforum.com/showthread...hreadid=381708 |
#4
|
|||
|
|||
Thank you for the feedback ... just glad that I can help. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=381708 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Remove text leading zero in text string | Excel Worksheet Functions | |||
Finding Specific Text in a Text String | Excel Worksheet Functions | |||
extracting data from a text string of varying length | Excel Discussion (Misc queries) | |||
Extracting Surname from within a text string | Excel Worksheet Functions |