TheCHAR functionreturns a character based on it’s numeric code.
The formula then uses the MID function to extract the desired line.
Finally, the TRIM function slices off all extra space characters and returns just the line text.
you could also use Control + J for new line during search and replace operations.
For example, =MID(“apple”,2,3) returns “ppl”.
SUBSTITUTE Function
The Excel SUBSTITUTE function replaces text in a given string by matching.
For example, =REPT(“x”,5) returns “xxxxx”.
LEN will also count characters in numbers, but number formatting is not included.
