Extract data in the right part of a cell

[plumstone]

I have some cells contains "*" , I want to extrat the text to the right of the "*". For example, if A2 contains "txt*123", I want it turn out to be "123".
Thanks.

 

[Chip Pearson]

Try the following formula,

=MID(A1,FIND("*",A1)+1,LEN(A1))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



message

I have some cells contains "*" , I want to extrat the text to

the right of the "*". For example, if A2 contains "txt*123", I
want it turn out to be "123".

 

[RagDyeR]

Try this:

=RIGHT(A1,LEN(A1)-FIND("*",A1))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have some cells contains "*" , I want to extrat the text to the right of
the "*". For example, if A2 contains "txt*123", I want it turn out to be
"123".
Thanks.

 

[plumstone]

I have just found the solution by myself after some nice guy below told me how to count the total number of characters in a cell. My solution is like this:
=MID(A2,FIND("*",A2,1)+1,LEN(A2))
You may have other solutions. Let's share.

 

[plumstone]

Thanks.

Try the following formula,

=MID(A1,FIND("*",A1)+1,LEN(A1))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



message

the right of the "*". For example, if A2 contains "txt*123", I
want it turn out to be "123".

 

[CLR]

Hi plumstone............

Assuming you want to do a whole column at once, you could highlight your
column with the data in it, then do Data > Text to columns, and use the *
as your delimiter........
this would separate your data into two columns, one with the text to the
left of the * and the other with the text to the right of the *...........

Vaya con Dios,
Chuck, CABGx3

I have some cells contains "*" , I want to extrat the text to the right of

the "*". For example, if A2 contains "txt*123", I want it turn out to be
"123".