Replace all with transverse

M

Mike Lewis

If there is always a "-" this will work

=RIGHT(D15,LEN(D15)-FIND("-",D15,1))&"-"&LEFT(D15,(FIND("-
",D15,1)-1))

Where D15 is the original text
-----Original Message-----
I need to replace the contents of each cell with the
Click to expand...
transverse of the cell contents, i.e. ALB-0.2400
transversed to 0.2400-ALB. Any possible solutions are
appreciated.
 
Top