How to convert once cell data in multiple cells

[THIRU_NANI (NaNi)]

Hi! welcome to community!

You can use String manipulation to achieve your requirement.

ex:-

Sample:

text.Split(" ".ToArray)(0).Replace("[","").ToString

Reference:-

How to manipulate a part of string: Split, Trim, Substring, Replace, Remove, Left, Right

Hi, if you are a beginner in the world of automation and would like to know how you can manipulate text based on the solutions available in the VB.NET code and using REGEX (regular expressions) then you are in the right place. In the topic below, you will learn how to easily extract data from any part of the search text using various methods. The topic includes solution examples with descriptions and graphics to better understand the topic for functions such as: Split Substring Left Right R…

Regards,
NaNi