1. On the TextJoin sheet, for rows 2-10 in Column F, use a TEXTJOIN formula to combine the data in columns A:D. Include a dash in between each cell's values
2. On the TextJoin sheet, for rows 13-30 in Column F, use a TEXTJOIN formula to combine the data in columns B:D. Include a space in between each cell's values and ignore the blank cells
3. On the ReplaceSubstitute sheet, in column B, complete the following:
   1. Rows 2-5: Use the Replace function to replace the 5^th character with "X"
   2. Rows 8-11: Use the Replace function to replace the 8^th character with "USA"
   3. Rows 14-17: Use the Substitute function to remove the 2^nd dash
   4. Rows 20-23: Use the Substitute function to remove only the 1^st dash
   5. Rows 26-29: Use the Substitute function to replace the 2^nd dash with "XXX"
   6. Rows 32-55: Use the Substitute function to replace all dashes with an underscore
4. On the TextLenRept sheet, in Column C, use a TEXT formula on the data in column A to make it look like the "desired" data presented in column B.
5. On the TextLenRept sheet, in Column E, use a LEN formula to calculate the length of the text in each cell in column D.
6. On the TextLenRept sheet in Column G, use a nested formula (meaning a function inside another function) on the data in column D to make it look like the "desired" data in column F. I need only number 6 A B c d e f g 2 Actual Desired 3 757 00757