Excel Forum
Similar Content
Calculate Percent Change in Excel
Tutorial: How to calculate the percentage amount that a value has changed in Excel. This includes q...
Input Form to Get Data and Store it in Another Tab in Excel
Tutorial: How to make a user input form in Excel and have the data stored on another worksheet at th...
How to Create and Manage a Chart in Excel
Tutorial: In this tutorial I am going to introduce you to creating and managing charts in Excel. Bef...

Excel Magic Trick 292: Reverse Last & First Name Tricks

See how to Extract First and Last Names and rearrange them using a formula. For example, go from Smitty, Sioux Z. to Sioux Z. Smitty and from Radcoolinator, Sioux to Sioux Radcoolinator.
REPLACE function replaces part of a text string with text you specify, given a starting number and the number of characters
FIND is similar to SEARCH, but it is case sensitive. FIND finds the starting position in a text string of text you specify. Example Find "d" in "suds' returns 3.
LEFT returns a specified number of characters from text string from the left
TRIM removes spaces from a text string except for single spaces between words
The LEN function counts characters
MID extracts characters from the middle of a text string given a starting position and number of characters

Tricks From Mr Excel Message Board Aladin Ron

Got a Question? Ask it Here in the Forum.