You are here:

Excel/Extracting characters from excel cell


Wayne Benhart wrote at 2011-05-12 18:23:36
Heres what I did with the list below to re-arrange "Last, First" to "First Last" by locating where a specfic character is located in a cell.  in this case it was a comma.  


  Benhart, Wayne

  Executive Conference Room    

  Fernandez, Jacqueline

  Ferrer, Rey


  Wayne Benhart

  Executive Conference Room

  Jacqueline Fernandez

  Rey Ferrer


Code Used:

=IFERROR(MID(TRIM(A1), FIND(",", TRIM(A1))+2, LEN(TRIM(A1)))&" "&LEFT(TRIM(A1), FIND(",",TRIM(A1))-1), TRIM(A1))

Hope this helps!!!


Enamul wrote at 2012-12-03 12:26:28
i have more easy formula, like:


i hope that this helps. pls let me know


Enamul Huq

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here


All Answers

Answers by Expert:

Ask Experts


Jessica L.


I can provide answers for most Excel problems. I don`t mind answering even the simplest of questions.


I am a self taught Excel user and have been using Excel for about 12 years.

©2017 All rights reserved.