I need to display all text after first comma in a cell in another cell. For example
Text in A1 = 1.1, 1.2, 1.3
I need to display in B1 all the text after the first comma which would be = 1.2, 1.3
Can anyone help?
I need to display all text after first comma in a cell in another cell. For example
Text in A1 = 1.1, 1.2, 1.3
I need to display in B1 all the text after the first comma which would be = 1.2, 1.3
Can anyone help?
Last edited by Neales; 09-10-2009 at 07:12 AM.
In B1:
=MID(A1,FIND(",",A1,1)+1,LEN(A1))
Very nice. Thanks for posting your solution, too.
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks