Hello,
Hope my excel tips are helping you out.
Here is the third tip for you. Hope this help you.
Using formulae (Alt+E+S+E) is very easy and effective.
Converting
Text
|
(Transpose
means - Converting Text from row to column or Vice-versa)
|
How to use
it :
|
Step 1-
Select the Text which you want to Transpose
|
Step 2- Use
Ctrl+C of the desired Row/columns
|
Step 3- Go to
the desired cell where you want the data
|
Step 4- Use Alt+E+S+E
and press Enter
|
The Text has
been converted
|
Here are
some Examples for the same.
If any of your
friend is also interested for the said excel Tips , then asked them to fill the
form by clicking on the below mentioned link:
If you have something that you want to share with the group,
please write to excelms.tips@gmail.com
Please do share
your valuable feedback. Keep Sharing.
Thanks & Regards,
CA Mohit Bansal
+91-9045773456
No comments:
Post a Comment