Dear Excel Community,
Currently I have the following formulas for formatting text in each cell within a certain column.
Selection.Replace What:=Chr(10) & Chr(10), Replacement:=Chr(10), LookAt:=xlPart
Selection.Replace What:=Chr(10), Replacement:=" "
However I wish to combine this process as I have a marker in another column whereby the cells will be indicated by the numbers 1 & 2.
How do I combine the above formulas into one script which can do the following,
If the adjacent cell in the column = 1 then use
Selection.Replace What:=Chr(10) & Chr(10), Replacement:=Chr(10), LookAt:=xlPart
If the adjacent cell in the column = 2 then use
Selection.Replace What:=Chr(10), Replacement:=" "
Any help will be greatlyy appreciated! Thank you.
Currently I have the following formulas for formatting text in each cell within a certain column.
Selection.Replace What:=Chr(10) & Chr(10), Replacement:=Chr(10), LookAt:=xlPart
Selection.Replace What:=Chr(10), Replacement:=" "
However I wish to combine this process as I have a marker in another column whereby the cells will be indicated by the numbers 1 & 2.
How do I combine the above formulas into one script which can do the following,
If the adjacent cell in the column = 1 then use
Selection.Replace What:=Chr(10) & Chr(10), Replacement:=Chr(10), LookAt:=xlPart
If the adjacent cell in the column = 2 then use
Selection.Replace What:=Chr(10), Replacement:=" "
Any help will be greatlyy appreciated! Thank you.