Reverse Names with Excel MID Function

If names are in Last, First order in an Excel workbook, use this MID formula to reverse them, in another cell.

The formula results will update immediately, if the name in the original cell is changed.

See how to build the 3 parts required for the MID function to reverse names.

To get the Reverse Names with Excel MID Function workbook, go to this page:

00:00 Introduction
00:22 Reverse Names
00:47 Get the Text String
01:35 Get 2 Numbers
01:53 Start Number
02:35 Number of Characters
03:02 MID Function
03:32 Test the Formula
03:47 Get the Workbook

Instructor: Debra Dalgleish, Contextures Inc.
#ContexturesExcelTips

[wayneedmondson]

Hi Debra. Interesting approach. My first pass at this was to use LEFT, RIGHT, FIND and LEN as in: =RIGHT(B2, LEN(B2)-FIND(" ", B2)) & " " & LEFT(B2, FIND(", ", B2)-1). Your approach is very clever with MID. Thanks for sharing :)) Thumbs up!!