I was wondering if there’s any way I could put a certain text in a text group and put it in each individual cells, here’s an example:
2544549379: “+3000”,
121260153: “+2000”,
21294489: “+3000”,
25545089: “+3000”,
153955396: “+1000”,
How would I make a command in a cell to only get the text “+3000”? and so on.
Hi Preston_Nguyen,
Welcome to the spreadsheet.com community.
Steps:
-
Have the data in “A” column and
-
Now edit the “B” column and update it to “Column Formula” data type with the formula i.e., REPLACE(A,1,SEARCH(" “,A),”").
Like below image.
-
Now observe the result as per the below screenshot
I hope, this is what you are looking for.
Please click the following link for a brief overview of “Text Functions.”
Text functions – Spreadsheet.com Support
1 Like