The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

text and numbers

ctf1800ctf1800 Member Posts: 6 Contributor II
edited November 2018 in Help

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

Sign In or Register to comment.