How to remove multiple strings in excel

Help Studio
, ,
1

Hi, I am creating a robot where it reads data from 2 columns without header.

I managed to remove the spaces, however there are some strings such as “Billing dept”, “Name”, “Total by Sub BU”, “Total by Billing dept”. Is there any idea how?

2

Hey, @TOBIAS_TOH_TENG_KIAT

I’m not quite sure if I followed your idea correctly after this:

Do you want to delete the string or do you want to remove the spaces in the string to turn them into something like “Billing dept” > “BillingDept”

3

Hi @TOBIAS_TOH_TENG_KIAT i am not cleared with your requirement

Can u explain it well please?

4

Hi @TOBIAS_TOH_TENG_KIAT ,

Perhaps below your main table, you have a couple of other tables.
The strings that you are seeing might be the headers of those secondary tables. It’s just an assumption

Best regards,
Marius

5

Let me take a picture and post it, to get a better picture

6

image
image2016×1512 1.35 MB

@NIVED_NAMBIAR
@hugo_varela
@Marius_Puscasu

So the excel sheet given is the screenshot above.

I will have to extract the data “10001145” and “Tampines Sec Sch” as it will be needed to generate a report. Is there any ways I can get them?

7

Hi @TOBIAS_TOH_TENG_KIAT

Did u tried using read range with range being specified
?

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed:

8

Hi @TOBIAS_TOH_TENG_KIAT

Here is the working solution based on suggestion by @NIVED_NAMBIAR
You may need to update the variables RangeIndex and Range.

Note on example book1.xlsx:

  • RangeIndex is 3 which is the starting row
  • Range is “C3:D4”

ExcelSCS.zip (9.9 KB)

1 Like
9

It’s working now. Cheers

10

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