Microsoft Office Forums - View Single Post - Formula Help Request

Thread: Formula Help Request

View Single Post

Old

02-21-2013, 04:06 AM

Kevin@Radstock Kevin@Radstock is offline

Kevin@Radstock is offline

Kevin@Radstock uses Windows 7 32bit

Windows 7 32bit Kevin@Radstock uses Office 2010 32bit

Kevin@Radstock uses Office 2010 32bit

Office 2010 32bit

Office 365

Join Date: Feb 2012

Posts: 94

Kevin@Radstock is on a distinguished road

Default

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

Reply With Quote