SEARCH and LEN

[ACarella]

I am trying to extract everything from the right into a column and then
everything from the left into another column. How would I do that?

FISHER=12345 FISHER 12345
ABCDE 50 .CPR = 123 ABC DEF ABCDE 50 .CPR 123 ABC DEF

Thank you

 

[daddylonglegs]

Assuming data in A1

=LEFT(A1,"FIND("=",A1)-1)

and

=REPLACE(A1,1,FIND("=",A1),"")

If you want to eliminate and surplus spaces then enclose the above formulas
in a TRIM function

 

[Bob Phillips]

=LEFT(A1,FIND("=",A1)-1)

and

=MID(A1,FIND("=",A1)+1,255)

 

[Bob Phillips]

or do a Data>Text to columns with a delimiter of =

 

[Harlan Grove]

Assuming data in A1

=LEFT(A1,"FIND("=",A1)-1)

If this were in B1, then . . .

=REPLACE(A1,1,FIND("=",A1),"")

.. . . this could be simplified to

=REPLACE(A1,1,LEN(B1)+1,"")

 

[ACarella]

I do not understand how to do what you have listed below. But would like
to. Can you explain. Your other response also worked.
Thank you.

 

[Bob Phillips]

Select the column with the data
Goto menu Data>Text to columns..
Click Delimited, then Next
Click the Other box, and input = in the next box
OK out

 

[ACarella]

I will check that out.
thank you.

Select the column with the data
Goto menu Data>Text to columns..
Click Delimited, then Next
Click the Other box, and input = in the next box
OK out


--
__________________________________
HTH

Bob