Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
AmyTaylor
 
Posts: n/a
Default 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   Report Post  
BenjieLop
 
Posts: n/a
Default


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   Report Post  
AmyTaylor
 
Posts: n/a
Default


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   Report Post  
BenjieLop
 
Posts: n/a
Default


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
Remove text leading zero in text string Peo Sjoblom Excel Worksheet Functions 0 May 27th 05 09:59 PM
Finding Specific Text in a Text String Peter Gundrum Excel Worksheet Functions 9 April 10th 05 07:21 PM
extracting data from a text string of varying length andy from maine Excel Discussion (Misc queries) 4 March 28th 05 07:11 PM
Extracting Surname from within a text string Iainkerr01 Excel Worksheet Functions 6 March 14th 05 11:16 AM


All times are GMT +1. The time now is 08:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"