How do I filter phone numbers from an Excel document?

Help Studio
1

Hello,

So I am building a process which takes an Excel document

Automation Careline
Automation Careline1219Ă—413 8.37 KB
which just wants a phone number from the data (preferably the mobile number) and will have a message next to the mobile number afterwards. I manage to delete the the unnecessary information, but next I need to have one row of phone numbers (preferably mobile) and have that move to column A. Any help?

Thank you

2

@deguy Can you Show us How do you Expect the Output Excel to be?

3

Macro is the best solution here. Create a macro imitating the manual steps. Use Execute Macro activity to run it.

1 Like
4

Capture
Capture1468Ă—403 7.19 KB
Something like this. It copies and pastes the mobile numbers into column A, then adds in phone numbers from the other columns if the field is blank.

5

WIll give this a go

6

@deguy So from the Input Excel File, You want only the “Mobile Telephone” Column to Remain with An Additional Column “Bulk Text” with values added to it?

or

You want the “Mobile Telephone” Column to be placed at the beginning with An Additional Column “Bulk Text” with values added to it and also keep other Columns?

7

The first one, the final document should only have those two fields. It has to be in this specific format of Mobile number in column A and bulk text in column B.

8

So I tried using the Macros on Excel, and it works but if the blanks in the mobile column are different, it cannot fill them in. Is there a way to do this in the Macros?

9

@deguy Can you tell me from where do you get the Values of Bulk text Column ?

10

The bulk text document will just be a line of text and will be the same everytime. Something like: “An engineer will be coming on XX date” and this will be for all rows in column B

11

@deguy Check this Workflow :
GetNonEmptyColumnValues.zip (8.2 KB)

Check the Excel File, It Has Sheet1 , which is the Input and Sheet2 which is the Output.
Delete Sheet2.
Execute the Workflow and Check the Sheet2 if that’s what the Output you needed.

12

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