“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

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

I need a formula to find text within a string of word and replace only that text but keeping the other words. For example: find "apple" and replace that with "Red" Apple Banana Orange to Red Banana Orange

Solved by A. F. in 12 mins

My excel sheet ROW name replace column name wise

Solved by F. L. in 25 mins

Hi, I have a list of categorical data consisting of strings constantly being uploaded from a survey. I want to find a specific portion of the string and replace the entire cell content with a numerical value. For example: Student A Yes, I use an iphone Student B Samsung Student C I use a google pixel I want to replace all contents of a cell that has a string containing "iphone" with the number 1, "samsung" with the number 2, and "google" with number 3. So that I would end up having Student A 1 Student B 2 Student C 3

Solved by F. J. in 16 mins