Posts by Haroldo Passos • 1 point

• -1

  votes

  1

  answer

  27

  views

  Q: Concatenate two columns with Excel Vba in six different tabs

  I need to concatenate with VBA the texts contained in two columns in Excel spreadsheet, joining them in another column, but performing this procedure for six tabs. The data of columns B and H need…

  excel-vba

  asked 3 years, 2 months ago Haroldo Passos 1

• 0

  votes

  1

  answer

  24

  views

  Q: Procv without the last character

  I have a procv, where I wrote the following: SE(ÉERROS(PROCV($A2;'PLAN2'!$A:$C;1;0));"Não Encontrado";"Encontrado") It works very well in exact cases of searching for values, but some cases have…

  excel procv

  asked 3 years, 3 months ago Haroldo Passos 1