8 Excel Text Manipulation Formulas you NEED in your Life
When it comes to data analysis in Excel or any other tool, everything can fall apart if you're data isn't stored in a consistent format. Often, the data you need is hidden in plain sight inside other fields. An example would be first name and surname which might be embedded in an email field just waiting to be extracted if you can just work out the pattern.
There are lots of formulas in Excel tailored to extracting exactly what you need and I'm going to show you 8 of them in this video. Whilst there are some up and coming new ones, the classics, and the ones you will find used in 99% of sheets where text manipulation is applied are
LEFT
MID
RIGHT
SUBSTITUTE
SEARCH
CONCATENATE
LEN
TRIM
...and we will cover ALL of these in this video with detailed examples.
Пікірлер: 2
Great Tutorial! The problem I have is when my data does not follow predictable patterns, and I end up having to nest 10-20 IF formulas to account for all the possibilities, and my formulas get to be pages long. This makes finding errors in my formulas a real pain and I end up having to paste them into Notepad++ to highlight matching brackets and such.
@excelgoat
11 ай бұрын
Yeah I feel your pain!. In environments where you have control over the input at that point it’s definitely best starting back at the point of capture and building in some validation or automation to ultimately reduce the post cleanse although I appreciate that’s often not a possibility if the data is coming from a third party source.