String split question

[tomwilson64]

I have several cells in a column which appear as follows (an abbreviated portion only):

FEIndex_0='499919'
To_6='TO FILE'
From_6='Wilson, Tom'
Location_6=''
Category_6=' '
SecurityLevelID_6='3'
Status_6='A'
VitalPeriod_6='0'
Subject_6='Change'

I would like to isolate the text to the right of the "=" sign. Because these are not fixed lengths I can't use a left, mid or right string function. When I use Crystal Reports, I use a function called split such as =split([variable],"=") [0] which takes the first portion of text before the "=" sign. I don't have that function in Excel. Without scripting is there a way to accomplish this?

Thanks!

Tom

 

[danzon]

how about

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

 

[jim may]

You mean, like this?

Excel Workbook
	A	B
1	FEIndex_0='499919'	'499919'
2	To_6='TO FILE'	'TO FILE'
3	From_6='Wilson, Tom'	'Wilson, Tom'
4	Location_6=''	''
5	Category_6=' '	' '
6	SecurityLevelID_6='3'	'3'
7	Status_6='A'	'A'
8	VitalPeriod_6='0'	'0'
9	Subject_6='Change'	'Change'
Sheet1

Excel 2007

Cell Formulas
Range	Formula
B1	=MID(A1,FIND("=",A1)+1,99)

 

[AlphaFrog]

<br /><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">FEIndex_0='499919' </td><td style=";">'499919' </td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">To_6='TO FILE' </td><td style=";">'TO FILE' </td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">From_6='Wilson, Tom' </td><td style=";">'Wilson, Tom' </td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style=";">Location_6='' </td><td style=";">'' </td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">Category_6=' ' </td><td style=";">' ' </td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">SecurityLevelID_6='3' </td><td style=";">'3' </td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style=";">Status_6='A' </td><td style=";">'A' </td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style=";">VitalPeriod_6='0' </td><td style=";">'0' </td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style=";">Subject_6='Change' </td><td style=";">'Change' </td></tr></tbody></table><br /><br /><table cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B1</th><td style="text-align:left">=MID(<font color="Blue">A1,FIND(<font color="Red">"=",A1</font>)+1,99</font>)</td></tr></tbody></table></td></tr></table><br />

 

[VoG]

Try

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

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=579108

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).