“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 VBA to replace formula i used to import data from 3 spreadsheets

Solved by C. C. in 28 mins

i need VBA code to replace formula import data from 3 spreadsheets even when they are closed

Solved by F. S. 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