Excel Q&A

Home

Forum

Advanced Excel Topics

Excel Q&A
- Excel Q&A

Ask your geeky hard core Excel questions here!

Questions/Discussions

Sort by Date ▼ / Top Rated

Text to Row

I know excel has a "Text to Column" function, but is there anyway to automate a "Text to Row" function. Please see below data. I would like to have Operator, Address, Phone, Operator, Address, Phone, etc., all on different rows going down the spreadsheet. Currently, each Operator... Read More

Show All 4 Replies Login to Reply

by Guest 1.

added 11 years ago

Re: Text to Row

Assuming that you do want to flip your data into a "table", i.e. transpose a single column of data to multiple rows, where each row is a different record like a database, follow these steps. Assuming your data (as you inputted in your initial question) is all in column A and starts in A1 ... Read More

by WST Expert 1.

added 11 years ago

Re: Text to Row

Thank you so much for response. That was very detailed and I definitely did learn from it. However, when I was most of the way through this, I realized my explanation must not have gotten a certain detail across. I apologize for the error. Each operator/address/phone combo are in its own cell. What ... Read More

by Guest 1.

added 11 years ago

Re: Text to Row

This will get kind of ugly but bear with us here: So say A1 is a cell containing "Operator: John Doe Address: 123 S Washington St. Phone: (123) 456-789" (including the line breaks). Then in B1, you want to separate out the Operator using this formula: =LEFT(A1,FIND("Address",A1... Read More

by WST Expert 1.

added 11 years ago

Show More Show Less