View Single Post
 
Old 02-21-2013, 08:34 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Quote:
Originally Posted by Kevin@Radstock View Post
Hi OTPM

Assuming your data is in A1, may be:

=LEFT(A1,FIND("+",A1)-3)&","&MID(SUBSTITUTE(SUBSTITUTE(A1,"SS",""),"SF", ""),FIND(",",A1)+1,LEN(A1))

Kevin
Many thanks for your response Kevin, I will try that.

Tony
Reply With Quote