Get instant live expert help on I need help with excel replace character in string
“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 to find and replace text in an excel spreadsheet base on content variables. The find and replace is larger than the 256 character limit.
Solved by F. L. in 26 mins
FORMULA TO PERFORM A MATHEMATICAL EQUATION ON A SET OF NUMBERS WITHIN A STRING OF NUMBERS, THEN REPLACE THE SET OF NUMBERS WITH THE MATHEMATICAL RESULT IN THE SAME STRING OF NUMBERS (EXAMPLE: 123456 STRING OF NUMBERS, & MATHEMATICALLY REDUCE THE MIDDLE NUMBER OF 34 BY 1, THEN REPLACE THE ANSWER TO THE ORIGINAL STRING RESULTING IN 123356)
Solved by D. J. in 30 mins
I need to find every cell with only one character in it and replace those cells with empty space
Solved by S. Q. in 28 mins
Hi, I am having trouble using find and replace in my worksheet. I am trying to find and replace a string of text that is part of a larger portion of text in the cells of one column of the worksheet. The problem is that the find and replace function is replacing the entire cell contents, not the string of text specified in find and replace.
Solved by K. J. in 30 mins
Want to have a series of cells return partial text string from a large text string, even if the character is a space
Solved by A. J. in 24 mins