Microsoft Office Forums - View Single Post - [Solved] I'm looking for a formula to extract all the text before the last name in a cell

Thread: [Solved] I'm looking for a formula to extract all the text before the last name in a cell

View Single Post

Old

02-01-2015, 07:05 PM

thetraininglady thetraininglady is offline

thetraininglady is offline

thetraininglady uses Windows 7 64bit

Windows 7 64bit thetraininglady uses Office 2010 32bit

thetraininglady uses Office 2010 32bit

Office 2010 32bit

Competent Performer

Join Date: Sep 2014

Location: Sydney, Australia

Posts: 214

thetraininglady is on a distinguished road

Default

Otherwise the Text to Columns function will separate text in a cell to multiple columns.

Reply With Quote