Home » Forums » Open Source Learning Center » Question and Answer

Copy Substring from a string

Submitted by alisag on 1 April, 2013 - 08:23

Hi,
I have a Cell Value "SG1+PA20-0328-01 D PCBA,15"DISP,5WIRE". How can i just copy in a new cell a value which starts after '+' and ends before first space. (PA20-0328-01).
Thank you...

‹ Vba code is running too slow Text boxes moving to Cell A1 on top of each other after turning off AutoFilter ›
»
Vishesh's picture

Suppose your value is in Cell

Submitted by Vishesh on 1 April, 2013 - 13:56.

Suppose your value is in Cell A1 then the required formula is

="("&MID(A1,FIND("+",A1)+1,FIND(" ",A1)-FIND("+",A1)-1)&")"

»