Get instant live expert help on I need help with excel carriage return
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need a formula to delete a carriage return and separate the street address, city, state and zip. I know about text to columns, but I cannot go in and change 1,900+addresses before I run it. Help please!!
Solved by Z. C. in 11 mins
Hi, i need to manipulate text. I am trying to insert a delimeter. i can do this one of two ways, ideally, with a line down (carriage return) and adding | instead of a text bullet, or by adding | at the end of a . or !
My current formula is: =CONCAT(FIND(".",M:M),IF(M:M,".",(SUBSTITUTE(".",".|","")),(FIND("!",M:M),IF(M:M,"!",(SUBSTITUTE("!","!|","")))
Solved by K. H. in 26 mins
What value would Excel return for this formula? =(82-32)/5+8*2
Solved by E. E. in 24 mins
I need an Excel formula that will return a week day if the results is a weekend.
Solved by M. A. in 12 mins
how do I get excel to return the data in a different (dynamic) cell while using IFERROR?
Solved by V. H. in 26 mins