Hi,

Let's say I have a para in the following FORMAT in Outlook or Word. I want
to keep a record of this in excel. When I copy , paste then in Excel the
indentations are not removed.

**Pasting from outlook as it is**
Tab Table 29-a - I see many numbers for the same attribute on different
tables. What is the correct number? For ex.
Table 29-a - ABC =76 and ABC =209
Table 27-12 - ABC =453
**Pasting ends**

I have used Trim function but the leading spaces before -- Table 29-A -- and
the leading spaces before Table 27-12 are not getting removed. I have to
manually get in to edit mode and remove the leading spaces. Is there any
other function which can align the above 3 rows in Excel

Please guide me

Thanks a lot,
Hari
India