I am looking to extract data from cells in google sheets, when enter the data i need to split up the data for example
all the above data would be in one cell however when i am typing the data back into another application ‘Linnel’ is the first name
‘R’ is the surname
‘WR2020707’ is a ref
‘BGC’ is a ref
How can i use that variable to input the data in specific fields rather then entering the whole data thats stored in the variable.
Each row will have different amounts of data, the bot will need to recognise the spaces in the data to separate the data.
can anyone help me please?