Copy text from word to excel with character limit in cell

Help
, , ,
1

I have a list of items that need to be copied from word to excel. The first cell has a limit of 60 characters and the second cell has a limit of 230 characters for each row(Spaces are counted as a character as well). I wonder how would split function or any other function that can help put in words into the next column for items that exceed the maximum amount of characters available
Thanks in Advance

2

Hi
Welcome to uipath community
Can I have an example if possible
Cheers @Chor_ym

3

Hi, Welcome to the uipath community forum
first you check how many characters are there in the string
Int variable = String.length
Then use
Id condition
If
Int variable > max characters allowed
Then
New string = string.substring(0,max characters length)

4

Pic
Pic1920×1080 173 KB

5

I only need to copy from 1 cell to another which has a word limit and not from word to Excel Sorry for the mistake

6

Hi can i have an example to see how it works