Excel append range

[0bb4628e217fd43ac86ac9294 (Rpauipathr)]

Hi friends,
I am facing with an issue I have an excel and I am doing vlookup in sheet1 and I am appending that data to sheet2 but after appending the data column is becoming as ########## instead of data it’s coming like this.

What to do can anyone help me.

[0bb4628e217fd43ac86ac9294 (Rpauipathr)]

Sorry it’s date column

[Anil_G (Anil Gorthi)]

@0bb4628e217fd43ac86ac9294

1. While reading check if display value is seected…if yes deselect it
2. It might be because of column width…increase it and check

Cheers

[0bb4628e217fd43ac86ac9294 (Rpauipathr)]

Display value you mean in properties

[0bb4628e217fd43ac86ac9294 (Rpauipathr)]

@Anil_G thank you for your fast response yesterday it’s because of column width but how can I resolve this issue

[Anil_G (Anil Gorthi)]

@0bb4628e217fd43ac86ac9294

Just increase the column size

You can use autofit range

Activities - Autofit Range

Cheers

[Vikas_M]

Hi @0bb4628e217fd43ac86ac9294 ,

You can use “AUTOFIT RANGE” activity in modern excel

Please find the screenshot below on how to use this activity

Hope it helps you out!

[0bb4628e217fd43ac86ac9294 (Rpauipathr)]

@Vikas_M can you show me how to use auto fill range in classic version

[Vikas_M]

Hi @0bb4628e217fd43ac86ac9294 ,

you can use macros in classic activity
Please find the workflow below
BlankProcess8 (2).zip (9.5 KB)

Before macro:

After macro is applied:

Hope it helps you out