text and numbers

ctf1800
ctf1800 New Altair Community Member
edited November 2024 in Community Q&A

i have a excel spreadsheet that has a comment field, i can get it to extract text but it drops the numbers, for example: this is a text field located at 211-0R1 at 2 pm.

i get back:

this    1

is       1

a        1

at       2

text    1

field   1

located 1

 

 

i also need:

2

211

0r1

 

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.