Add value to Excel cell but keep existing value

Help Studio
, ,
1

Hi guys,

So I want to add 00 in front of every cell in a range. How can I do this. I want to keep the value inside the cells but just add 00 in front. I’m doing format cell to “Text” then what?

Thanks

2

HI,

Can you share specific sample input and expected output? It’s no problem if dummy data.

Regards,

3

Yes so the cell contains value 49535234. I want to add 00 infront so after the bot finishes the value in the cell to be 0049535234.

4

Hi,

How about the following sample?

image
image833×761 25 KB

Sample20221108-2.zip (11.5 KB)

Regards,

5

So will this add 00 infront of my text and keep the rest that was already there?

6

HI,

Th above set format as 0000000000 style, as the following.

image

This assumes each data is numeric and result is fixed digits.

Regards,

7

Niiice. Thank you so much!

1 Like
8

Hello again, I’m having another issue now. When I export the file to CSV the 00 infront goes away.

9

Hi,

Because csv doesn’t have format information. Basically, we need to export it as string (text)
How did you export to CSV file?

Regards,

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.