Past Tip of the Day
Travis asks "I am trying to format some text into separate columns. The text is in one
column as follows:
Company Name B Company Name C Company Name D Company Name E Company Name F
Company Name B
Company Name C
Company Name D
Company Name E
Company Name F
When I formatted the test to excel I made this column as illustrated above. I would like to know of a formula to which I can make the data appear on one
All on the same ROW
Column A                       Column B          Column C
I have use vlookups and hlookups and pivot tables but I can-t figure out how to get the date if a row-by-row way.
I have been able to get company names to appear row-by-row in one column by sorting and I figured that I could use a combination of a vlookup with a
I think this can be easily achivied using a macro. Try this one.
LastRow = Range("A65536").End(xlUp).Row
While i <= lastrow
MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.