Get instant live expert help on I need help with excel replace character
“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
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
I need to find formula to find special character on excel
Solved by I. B. in 25 mins
I WOULD LIKE TO FIND THE DOUBLE QUOTE IN A CELL AND REPLACE IT WITH "DITTO". COLUMN A CONTAINS CHARACTER NAMES. COLUMN B CONTAINS THE ASSOCIATED BOARD GAME.
EXAMPLE CELL A1 CONTANS [ PROFESSOR PLUM ], CELL A2 CONTAINS [ COLONEL MUSTARD ] NOW IN CELL B1 CONTAINS [ CLUEDO ] AND CELL B2 CONTAINS [ "" "" ]. NOW IF I WANT TO REMOVE THE DITTOS IN A NEW COLUMN, E.G. COLUMN C. WHAT FORMULA CAN I USE TO REPLACE THE DITTOS WITH [ CLUEDO ]? THANKS FOR YOUR HELP.
Solved by V. J. in 20 mins
My excel sheet ROW name replace column name wise
Solved by C. A. in 30 mins