02-21-2013, 08:34 AM
|
Expert
|
|
Join Date: Apr 2011
Location: West Midlands
Posts: 981
|
|
Quote:
Originally Posted by Kevin@Radstock
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
|