# extract part of a cell's text

Options
edited 12/09/19

Hello,

New smartsheet user here.

I have cells that contain dimensions of objects. A cylinder, for example, looks like this: Ø120*12. I need a way to extract just the text to the right of the *, in this case 12, to another cell. Another example: Ø18*1000 would return 1000.

How do you do this?

Thanks!

• ✭✭✭✭✭✭
Options

Hi Ty,

Yes, there is.

In my example, I'm using the functions MID and RIGHT.

Try something like this for the first one.

=MID(Dimension@row; 2; 2)

The same version but with the below changes for your and others convenience.

=MID(Dimension@row, 2, 2)

Try something like this for the second one.

=RIGHT(Dimension@row; 4)

The same version but with the below changes for your and others convenience.

=RIGHT(Dimension@row, 4)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

@Paul Newcome As always, thank you for this - I was looking for a formula to pull only the text to the right of a character. I'm so thankful that you already had it written out for me!

• ✭✭✭✭✭
Options

@Paul Newcome I was looking for EXACTLY this solution! THANK YOU!!!!

=RIGHT(Dimention@row, LEN(Dimension@row) - FIND("*", Dimension@row))

• ✭✭✭✭✭
Options

@Paul Newcome thank you! this is what I needed!!! :)

=RIGHT(Dimention@row, LEN(Dimension@row) - FIND("*", Dimension@row))

• Options

I need a way to extract just the text MEGA MALL. I have 3,000 rows like this one.

LOW - VS-87 - Service-FS Battery Replacement Lead-MEGA MALL-1259410

• ✭✭✭✭✭✭
Options

@Marilen.Navarro103391 What are the consistencies in your text strings? Will it always be after the 5th "-"? Will it always follow "Lead-"? Will it always come immediately before the last "-"?

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!