FIND() LEN() LEFT() RIGHT() Functions Advanced Extract Text From Cells in Excel P.2

http://www.TeachMsOffice.com

PART 2
This tutorial shows you how to pull text from cells and separate them into multiple columns. This is an advanced tutorial that gives a detailed explanation of how to use the LEN() and FIND() Functions and Formulas in excel.

http://www.TeachExcel.com

Category:

Education

Tags:

• excel
• advanced
• text
• editing
• formulas
• len
• find
• left
• right()
• functions
• manipulation
• to
• columns

[identity4free]

Hi. Thanks for the great tutorial. I have a problem. Please can you help me how to extract/generate 4-letter name from a list of names? Thank you.

[ExcelisHell]

@identity4free How do you want to generate the 4-letter name? Just message me on here and I can help you from there.

[skept725]

let me start by saying this is an excellent example. I'm trying to use this formula to solve a problem with a column pre-filled with about 200 addresses. If I understand how this formula works, it would only make sense if number of spaces were exactly the same. I'm trying to separate physical address, city, state and zip. Can you do an example with different addresses?

[ExcelisHell]

there are a lot of different ways to separate data from cells and it can get very complicated depending on what you're doing. You can send me a message on here with an example of what you're trying to do and I can help you with that but without knowing what you need the data separated by, it will be hard to make a tutorial useful for you.

[WAQAS119]

What if a sentence consists of five or more words (separated by space) and you want to extract forth word? What can be done in this scenario?

Your help will be appreciated alot.

[karnail2011]

hi ExcelisHell

Fair value of plan assets first of year, $ 150000, $ 161,500 $ 195,500

Accrued benefit obligation ( ABO) for , 150,000, 289,000 363,300

Current service cost for year, 16,000,17,500 19,000

Can you change it in excel like

Fair value of plan assets first of year, $ 150000,  $ 161,500 $ 195,500

in different cell like 4 cell

Thanks

[dren003]

idol..^^ thanks.

[tirathmistry]

awesome tutorial thanks for putting useful tutorial your explanation is also awesome.

please put financial function tutorial video

thank you

God bless