i have my data in A3:A7
HD-01-01
SP-126-01
HD-02-05
CD-80-04
GD-1000-01
and B3:B7
10000
20000
30000
40000
50000
i want take any char between -*-
i have my data in A3:A7
HD-01-01
SP-126-01
HD-02-05
CD-80-04
GD-1000-01
and B3:B7
10000
20000
30000
40000
50000
i want take any char between -*-
=LEFT(RIGHT(A3,LEN(A3)-SEARCH("-",A3)),SEARCH("-",RIGHT(A3,LEN(A3)-SEARCH("-",A3)))-1)
"lunar_star" wrote:
>
> i have my data in A3:A7
>
> HD-01-01
> SP-126-01
> HD-02-05
> CD-80-04
> GD-1000-01
>
> and B3:B7
> 10000
> 20000
> 30000
> 40000
> 50000
>
> i want take any char between -*-
>
>
> --
> lunar_star
> ------------------------------------------------------------------------
> lunar_star's Profile: http://www.excelforum.com/member.php...o&userid=36882
> View this thread: http://www.excelforum.com/showthread...hreadid=565978
>
>
i want sum money in with
HD | SP | CD | GD
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks