Extract data from column

[udprocks]

Hi All,

I have sheet which have data in a column which messed up, I need separate data from there? if possible?

here is the cross post link

https://chandoo.org/forum/threads/ex...-column.44166/

Please check below Data.

Alex HorneDRE #: 02037293949.270.0440alex.horne@elliman.com


I need like
Name Phone Emila
Alex Horne 949.270.0440 alex.horne@elliman.com

Best.

[alansidman]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

[Limor_OP]

Message deleted.

[udprocks]

sorry not able to see reply

showing

message deleted

[Limor_OP]

Hi,
sorry but you need to provide the required cross-post link(s) from the other forum where you have posted the same message.
Otherwise - you cannot be answered.

[AliGW]

The link has been provided, so please provide your solution now. Thanks.

[Limor_OP]

I was just wondering if you have tried the 'text to column option?

[udprocks]

I was just wondering if you have tried the 'text to column option?

Alex HorneDRE #: 02037293949.270.0440alex.horne@elliman.com

I need like
Name Phone Emila
Alex Horne 949.270.0440 alex.horne@elliman.com



Not able to do with text to column due to, after "DRE#: " there is 8 digits after that our phone number also name length not same.

check plz if you have moment.

[Limor_OP]

can you upload a file with a few lines for example?

[alansidman]

Using Power Query, here is the Mcode

Please Login or Register  to view this content.

[udprocks]

can you upload a file with a few lines for example?

check now please.

[alansidman]

Your file attached with my Mcode in place

[Limor_OP]

Hi,
I managed to do that with the "text to column--->Delimited " option.

It still gives you the phone# and E-mail on samt column, so you need then to choose this column only and text to column it by choosing "Fixed width", move the cutting line in the proper places and you will get seperate columns either for the Telephone# & for the E-mail address.

As for the DRE and in order to combine first & last name ---> use this formula in adjacent clear column to lose the unwanted suffixes
=A2&" "&LEFT(B2,LEN(B2)-3)


Hope this will do the work.

[udprocks]

Hi,
I managed to do that with the "text to column--->Delimited " option.

It still gives you the phone# and E-mail on samt column, so you need then to choose this column only and text to column it by choosing "Fixed width", move the cutting line in the proper places and you will get seperate columns either for the Telephone# & for the E-mail address.

As for the DRE and in order to combine first & last name ---> use this formula in adjacent clear column to lose the unwanted suffixes
=A2&" "&LEFT(B2,LEN(B2)-3)


Hope this will do the work.

thank you so much, appericiate your quick solution. Its work like charm.

[udprocks]

check now please.

Tahnk you , thank you!!! so much sir, You are awesome!!!

Alyaws remeber your help here.