Take input from one cell, and format text in a specific way?

Not really sure how to ask this exactly, but I have measurements in one format, and I want to paste them into Excel and have Excel automatically re-format them in a specific way.

Example:

Text I am copying into Excel = 37.4 in [950 mm]
What I want Excel to output in the column beside it = 37.4" (95 cm)

Is this even possible?

Thanks!

Hi CK76 - It will always be in that format. I am copying and pasting from a web page and it will alwasy look like that and I will alwasy want the output in the way I listed above. Thanks!

Great! Thank yo u very much. Works perfectly!

You are welcome

If this solved your issue, please mark the thread as solved by using thread tools found at top of your initial post.

I will mark it solved! but just thought of another question along the same lines. Is there a way to take the attached file amd make the data output similar to how it is in ROW 1?

Note that in some cases there will not be a value in one or more of the columns so in those cases, an NA or leaving it blank is fine.

Thanks!!

(not sure if I uploaded the file correctly or not, so here is a link. https://1drv.ms/x/s!Ahwwhv7HNLano5B_gTen46bg6NnY7Q

Thanks, again CK76 - This worked wonders for what I need it for. Greatly appreciate it!