Pages

Tuesday, April 12, 2011

Use the SUBSTITUTE function to combine and separate - Text Functions - Microsoft Excel Tutorials


To combine several columns into one column, the & operator is used. To include a separator between each part in addition to blank spaces, here is a way to specify the separator just once while using the SUBSTITUTE function.

To combine and separate at the same time:

1. In columns A to E, type any kind of data.
2. Select cells F2:F10 and type the following formula: =SUBSTITUTE(A2&" "&B2&" "&C2&" "&D2 & " "&E2," "," - ").
3. Press <-Ctrl+Enter->.




Watch the Video Tutorial - https://www.youtube.com/watch?v=W97UrtPDTKo

Hope You Like This Tutorial - Give Comments

No comments:

Post a Comment

Submit Site to Google Free Articles Search Engine Submission - AddMe Directories Suggest Link Business Directory AutoBackLinks Directory Bingo Bahia Submission Software Reviews